MySQLTuner

Nessus is one of those applications that makes me happy and drives me crazy at the same time. It does what I need it to, but it’s often hard to get it rolling when it needs to do something for me. When I run it, I run it in batch mode, which requires [...]

Thanks to some work started by Ville Skyttä, MySQLTuner is now included in Fedora 9 repositories: # cat /etc/fedora-release Fedora release 9 (Sulphur) # yum info mysqltuner Loaded plugins: fastestmirror, priorities, refresh-packagekit Loading mirror ... [More] speeds from cached hostfile * updates: mirrors.usc.edu * fedora: mirror.unl.edu * livna: mirrors.tummy.com Available Packages Name : mysqltuner Arch [...] [Less]

If you run a fairly busy and/or badly configured MySQL server, you may receive something like this when attempting to connect: # mysql ERROR 1040: Too many connections MySQL is telling you that it is handling the maximum connections that you have configured it to handle. By default, MySQL will handle 100 connections simultaneously. This is [...]

Thanks to some hard work from Oden Eriksson and Frederik Himpe, MySQLTuner 0.9.1 is available in a Mandriva package.

There was a bug in versions of Plesk prior to 8.3 where the AWStats statistics for the previous months were unavailable. It was a bug within Plesk’s AWStat’s implementation, and it was fixed in Plesk 8.3. However, the fix only corrected the issue moving forward after the upgrade. There was no automated way to [...]

As some of you might know, I interviewed for a position at Google in April of this year. It wasn’t a position that I sought out, but it all came about after I received an e-mail and phone call from a recruiter. Obviously, there’s some things I can’t talk about with regards to [...]

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 ... [More] holes behind that it hopes to fill in later. If the size and quantity keep climbing, the holes can cause performance [...] [Less]

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 [...]