MySQL Is Huge

Take note of this graphic. Notice there’s been 3,775,826 queries processed by that MySQL server in a little more than 5 days. Nothing too impressive right? Right.
Lots of Queries

We know MySQL can handle many more queries than that in a much shorter period of time. What amazes me is how well MySQL performs on the server it’s running on. The box hosting that MySQL server is an old HP. It’s got 1 Pentium II 400mhz processor with 128Mb of RAM. And it serves data to anywhere between 10 and 14 seperate PC’s at any given point in time. In addition to that, this MySQL server also provides data to a web interface that is used by 50 or so people. The MySQL server pumps out about 500Mb worth of data every day.

MySQL never ceases to amaze me in what it can do on less than optimal hardware.

Advertisements

Restoring a Hacked Linux Server

This is a great post at MDLog. Marius goes into great detail on how you should respond when you know a linux server has been compromised.

It’s an interesting read if you’ve ever had the opportunity to be the administrator of a linux server. Probably interesting if you haven’t had that opportunity. None of my systems have ever been hacked, and I admin about 5 linux servers both at home and work. I’ve always sort of had a plan of attack though in the event it did happen. And, I’m happy to say, it would look very similar to Marius’s post.

Apache httpd 2.2.0

The Apache httpd server version 2.2.0 has been released. You can see the official announcement in the mailing list archives.

The Apache Software Foundation and The Apache HTTP Server Project are pleased to announce the release of version 2.2.0 of the Apache HTTP Server (“Apache”).

We consider this release to be the best version of Apache available, and encourage users of all prior versions to upgrade.

Apache HTTP Server 2.2.0 is available for download from:
http://httpd.apache.org/download.cgi

Apache 2.2 offers numerous enhancements, improvements, and performance boosts over the 2.0 codebase. For an overview of new features introduced since 2.0 please see:
http://httpd.apache.org/docs/2.2/new_features_2_2.html


The upgrade went very well for me. I was already running 2.0.55 though. The only thing I had to do was recompile PHP, which wasn’t a problem. I haven’t noticed any problems at all so far, as expected.