myisamchk If you’re reading this, it’s probably because you’re trying to run myisamchk on a large table and you want to set the –sort_buffer_size to some large value. That’s advisable, of course. However, it seems that some versions of MySQL don’t understand a 2-digit value for that parameter. I was trying to do the following: myisamchk -f -r –update-state –key_buffer_size=4G –sort_buffer_size=16G –read_buffer_size=32M –write_buffer_size=32M /var/sql/myisam-temp/mastersitedb/applicants_master_search – recovering (with sort) MyISAM-table ‘/var/sql/myisam-temp/mastersitedb/applicants_master_search’ Data records: 0 – Fixing index 1 myisamchk: error: myisam_sort_buffer_size is too small MyISAM-table ‘/var/sql/myisam-temp/mastersitedb/applicants_master_search’ is not fixed because of errors Try fixing it by using the –safe-recover (-o), the –force (-f) option or by not using the –quick (-q) flag If you’re getting an error like that, try using … Continue reading
Atypical Post This post isn’t only for you, but also for me. I have roughly sixteen 120V 1300-1500VA UPSes in my basement of various ages. They each take two SLA 12V ~8Ah batteries. As such, I need to replace those batteries periodically. Being a cheap bastard, I don’t buy the branded APC or CyberPower packs, but go for inexpensive generics from eBay or Amazon. In theory there’s no difference, but in practice some cheap batteries are, well, cheap. I’m attempting to figure out which off-brand brands work best. This Log Hence I’m going to start logging battery replacements to get an idea of which brand(s) represent the best value and longevity. This will always be a work in progress, because … Continue reading
The Echo Look I’m working on a full review-type-thing of the Look, but who really cares about that? I’m sure people will want to see the insides of it, though. The most interesting two things on it are an Intel RealSense SR300 module (minus its visible light camera), and what’s basically a full Intel PC motherboard. In fact, here are the main specs: Intel Atom x5-Z8350 (SR2KT) @ 1.44Ghz (1.91Ghz burst) 8GB Samsung eMMC Flash NAND Storage 8GB Elpida LPDDR3 RAM Broadcom 802.11ac + 802.11b/g/a/n + Bluetooth (Not sure of the version) The hardware is fantastically made and well put together, and overall is very clever considering they stuffed all of it into a diminutive cylinder! The Reassembly I did … Continue reading
ZeroFiller (for Windows!) This might be a relatively niche utility, but I figured I’d share it because it might help someone in the same situation. File Version Description ZeroFiller-v0.8-20171023.zip v0.8a2017-10-23 The ZeroFiller executable only (requires .NET 4.5.2) ZeroFiller-src-0.8a-20171023.zip v0.8a2017-10-23 The ZeroFiller source code (requires >= Visual Studio 2017, probably) Backups I run a lot of VMs and I’m a bit obsessed with backups. I do high-level backups (meaning files, DB data, configs, etc.), as well as low-level backups of the actual VM disk images. The raw virtual disks get snapshotted on the host system, then the snapshot’s raw data is backed up using dd, gzip, and rsync. It’s not fancy, and it basically grabs the machine in a crashed state … Continue reading
I’m a leftie, but all my life I’ve used right-handed mouse in my left hand. I needed to replace my old Microsoft Optical Mouse, and found the DeathAdder Left-Handed Edition. It’s the perfect size and shape for me, but they did the weird thing of switching the left- and right-click buttons. It’s easy enough in most any operating system to swap the buttons in the settings. However — at least with Windows — the buttons are only changed locally. So when connecting to other hosts via Remote Desktop the buttons revert to their hardware configuration. That’s a no-go for me, but I liked the mouse so much that I decided to mod the hardware instead. Fortunately, it’s very easy to … Continue reading
This video covers almost everything you need to know about HDDs and SSDs to make an educated choice before pulling the trigger on a purchase.
Well, almost everything. This video is primarily directed at the home user trying to get some additional storage, whether that be an extra drive in their workstation, a NAS, or a full file server. If you’re trying to choose between SAS drives for a large-scale datacenter installation, then you probably know this stuff already.
As I promised in the video, here’s some links to my HDD TCO worksheet from 2013 (though I may have updated it in the interim with a couple of “new” drives). Please download the Excel version and use this for any drive that you want. If you make any interesting changes or large scale updates, I’d love to see it, so please let me know!
I also added a bunch of notes so you know what I meant with all the field names.
This video features a review and teardown of the Intel Mini PC G2 manufactured by — uhhh — Random Chinese Company 5000.
Did it ship with tons of bloatware and malware? Is it too good to be true that it comes with a full copy of Windows 10? Are the specs worth a damn in the real world? Watch me ramble on about it to find out!
If you want to buy this cylindrical masterpiece mediocrity, a link to the original AliExpress listing is below (which may be way out of date by the time you read this). Note that this is not an endorsement and I don’t receive one penny if you do end up buying it.
TL;DR I’m a bit long winded, I know. If you’re pulling your hair out, scroll right down to the solution (which of course may or may not match your actual problem). Background I’m posting this because there is very little information on Google regarding these particular error messages, and I’m hoping that this will help point you in the right direction if you’re having the same issue. I have a new FreeNAS server that’s going to be serving my home network via SMB / NFS, but I also wanted to give my dev and production environments access to its main storage pool for non-critical file systems (backup staging, test environments, etc). My TCP/IP networks (home/dev/prod/management) are rigorously firewalled off from … Continue reading
I recently got a good deal on a 120V 3000VA APC SURTA3000XL, a 120 pound beast of a double conversion online UPS which boasts over 30 mins of runtime at half load (and that’s still over 1000 Watts)! It didn’t come with batteries, so this video shows the process of “refurbishing” a couple of old modules with new batteries, and testing out the UPS.
The reason I was hunting down reasonably priced DCO UPS wasn’t because I’m especially concerned about poor-quality power from my wall, but because I needed a UPS that would play nice with generator power.
I’d love to be able to afford a couple of ~7500 Watt inverter style generators (one primary and one backup) to run the whole house during a power failure, but the best I can do is a pair of contractor style gensets. They’re noisy and output a mess of voltages and frequencies, but they work. Well, they didn’t work with line interactive UPSes, but they’ll work fine with something like this APC.
I'm a computer guy with a new house and a love of DIY projects. I like ranting, and long drives on your lawn.
I don't post everything I do, but when I do, I post it here. Maybe.