Category Archives: MySQL

MySQL-related

Silicon Valley Codecamp 2011

Posted on October 9, 2011 by Administrator

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

Posted on October 3, 2011 by Administrator

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

Posted on October 2, 2011 by Administrator

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

Posted on September 26, 2011 by Administrator

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

Posted on August 21, 2011 by Administrator

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