Category Archives: MySQL

MySQL-related

Silicon Valley Codecamp 2011

Silicon Valley Codecamp 2011 was held this weekend at Foothill College near San Jose. There were 209 sessions and 3,414 registered attendees. I did not attend, but have seen some of the talks at other conferences in the past year. … Continue reading

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

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, Cassandra, 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