MySQLTuner

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 ... [More] a bash script equivalent of hwraidinfo which will work in Linux: #!/bin/sh SLOTLIST=$(hpacucli [...] [Less]

I’ve received some great feedback on my first screencast. The suggestions have been helpful, and the compliments have made me want to create more free screencasts. At this point, I’m opening it up to you - what would you like to learn? Of course, I’m still planning to make a full set of screencasts [...]

MySQL has quite a few cryptic error messages, and this one is one of the best: mysql> DROP USER 'forums'@'db1.myserver.com'; ERROR 1268 (HY000): Can't drop one or more of the requested users Naturally, I was quite interested to know why MySQL wasn’t going to allow me to remove this user. There was nothing special about the user, [...]

I received an e-mail from Tim Linden about a post he made in his blog about backing up MySQL data to Amazon’s S3. The article goes over installing the Net::Amazon::S3 Perl module via WHM (which is handy for the cPanel users). However, if you’re not a cPanel user, you can install it via CPAN: # perl [...]

I’ve discovered one of the most awesome applications for a Mac called ScreenFlow (#3 on my list after #1 TextMate and #2 Adium and I decided to put it to use for my first screencast. This screencast will teach you how to write a basic PHP script that will query data in MySQL. It is [...]

I just received a Google Alert about MySQLTuner being the Debian Package of the Day!

I’m really enjoying the Parallels Summit in Washington D.C. this week. The folks from Parallels have been great, and the vendors we have met are selling some pretty tremendous products. Lots of folks have been asking for a summary of what’s going on after my Twitter posts appeared earlier today. Here’s the latest information [...]

I’ll be taking a short break from posting, but I should be back underway within week!  Here’s what I’m working on during the break: MySQLTuner - Thank you for all of the e-mails with suggestions, patches and complaints. The 1.0 version of MySQLTuner is in the works and I hope that it helps you get [...]

Normally, qmail will be able to process the mail queue without any interaction from the system administrator, however, if you want to force it to process everything that is in the queue right now, you can do so: kill -ALRM `pgrep qmail-send` If for some peculiar reason you don’t have pgrep on your server, you can go [...]

Upgrading Plesk from 7.5.x to 8.x will change your Plesk-related MySQL tables from MyISAM to InnoDB. This allows for better concurrency in the Plesk panel when a lot of users are logged in simultaneously. However, some server administrators will disable InnoDB support in MySQL to save resources. This will cause problems after [...]