MySQLTuner v0.9.1 is now available! This long-awaited update includes bug fixes, feature enhancements, and compatibility improvements.
MySQLTuner now checks for fragmented tables
When deletes or updates are made on tables, MySQL will often leave holes behind that it hopes to fill in later. If the size and quantity keep climbing, the holes can cause performance [...]
I found myself in a peculiar situation last week. I’d been asked to downgrade a server from MySQL 4.1 to MySQL 3.23. Believe me, I tried to advise against the request, but I didn’t succeed.
I made a MySQL 3.23 compatible dump with –compatible=mysql323, but the dump came out with backticks around the database [...]
It seems like I have a conversation like this one at least once a week:
Them: “Hey Major, you’re a pretty nerdy guy, what server distro do you use?”
Me: “I use CentOS 4 right now.”
Them: “CentOS? Why not use something more cutting edge, like Fedora or Gentoo?”
Me: “Well, I like those, but Plesk works really well [...]
One of the most frustrating aspects of CPAN is connecting to mirrors via FTP. Most of the time, the mirrors are extraordinarily slow when it comes to FTP logins, and they often fail. As we all know, RHEL enjoys pulling some shenanigans (Scalar::Util - enough said) when perl receives an upgrade, and when [...]
Working with the RAID configurations on Linux can be a little involved if all you have is hpacucli. Luckily, the folks using HP’s OS distributions will get tools like hwraidinfo and hwraid status, but you can get these going in Linux as well.
Here’s a bash script equivalent of hwraidinfo which will work in Linux:
#!/bin/sh
SLOTLIST=$(hpacucli [...]
