Category Archives: MySQL

MySQL-related

Munin Plugin for MySQL Performance Hit and Miss Rates

Munin is an Open Source tool for monitoring servers. Here’s a plugin I wrote to calculate and display the performance of various MySQL read and write caches. You can download the plugin source here. Note that hit rates are seldom … Continue reading

Posted in Linux, MySQL, Open Source, Perl, Storage, Tech, Toys | Leave a comment

Netflix and Cloud IT

I recently did some technical consulting for Netflix. I can say that they are really, truly committed to cloud IT, per their public pronouncements. Most large companies are still just dipping a toe in the water, so it’s significant that … Continue reading

Posted in Business, Cloud, i18n, Linux, MySQL, Open Source, Oracle, Perl, Storage, Tech, Toys | Leave a comment

Checking MySQL Hosts in Parallel with Perl Threads

Here’s an example of using Perl ithreads to do monitoring of multiple MySQL hosts in parallel. Note that with older versions of Perl, you can use fork() or the forks.pm module instead of threads. #!/usr/bin/perl use threads; use 5.8.1; use … Continue reading

Posted in Linux, MySQL, Open Source, Perl, Storage, Tech, Toys | Leave a comment

Stupid Apache HTTPD 2 Tricks

I recently updated a linux web server to CentOS 6 with all new software packages. I noticed some disturbing things related to Apache HTTPD: many apps are adding .conf files to /etc/httpd/conf.d, which was intended for virtualhosts. So guess what … Continue reading

Posted in Linux, MySQL, Open Source, Perl, Storage, Tech, Toys | Leave a comment

OSCON 2011, Portland

Once again, the O’Reilly Open Source Conference (OSCON) was held in Portland, Oregon. It was held in parallel at the Oregon Convention Center with the O’Reilly OSdata and OSjava Conferences at the beginning of the week, and then later a … Continue reading

Posted in Business, Conferences, i18n, Japanese, Linux, MySQL, Open Source, Oracle, OSCON, Perl, Photography, Psychology, Storage, Tech, Toys, Travel, User Groups | Leave a comment