MySQLTuner

I set up a system at home that has two SATA controllers: one is on the motherboard (nvidia chipset), while the other is on a Silicon Image SATA card that has three eSATA ports. Here is the relevant lspci output: root@storageserver:~# lspci | grep ATA 00:08.0 IDE interface: nVidia Corporation MCP61 SATA Controller (rev a2) 00:08.1 IDE [...]

Some of you may be wondering “why would you want to use Rails without a database?” There are several situations why a database would not be needed, and I’ve run into quite a few of them. One of the specific cases was when I wanted to write a web interface for an application [...]

I’ve received a lot of questions lately about Slicehost and how the service works. If you want to know more, check out the “Getting started with Slicehost” screencast that I’ve created. It goes over the following steps: Signing up for a Slicehost account Provisioning a new slice Features and functions of the Slicemanager Setting up a LAMP [...]

I enjoy using CPAN because it installs Perl modules with a simple interface, fetches dependencies, and warns you when things are about to end badly. However, one of my biggest complaints is when it constantly confirms installing dependencies. While this is an annoyance if you have to install a module with many dependencies [...]

I’ve moved all of this blog’s CSS, javascript, and most of the images to Rackspace’s Cloud Files so they can be served via the Limelight CDN. So far, this has cut the load times in half. Most of the edits aren’t supported by Wordpress, so I ventured into the source code for my plugins as [...]

I’ve upgraded the blog successfully to Wordpress 2.7 (with a bit of frustration). When I attempted the upgrade, I received this error: Call to undefined method wpdb::has_cap() in schema.php on line 22 Even though I followed the instructions on the Wordpress site, and I disabled all of my plugins, the error kept appearing. The only [...]

When it comes to frustrating parts of the Linux kernel, OOM killer takes the cake. If it finds that applications are using too much memory on the server, it will kill process abruptly to free up memory for the system to use. I spent much of this week wrestling with a server that was [...]

You can use the simple but powerful xinetd on your Linux server to monitor almost anything on the server. Since xinetd just holds open a port and waits for a connection, you can tell it to run a script and return the output directly to the network stream. To start, you’ll need a script which [...]

It has finally arrived. MySQLTuner 1.0.0 is now available for download. Major improvements include full support for MySQL 5.1 and Solaris. You can review other changes in the changelog. As always, I’d like to personally thank everyone who has made this release possible. Your efforts have provided benefits from MySQL users worldwide, [...]

If you run a Wordpress blog, and you haven’t upgraded to Wordpress 2.6.5, you might want to make the move soon. There were a few bugs and security issues fixed, along with other changes.