mysqltuner.pl

Thanks to Tim Hawkins, our new Director of App Dev in our Pasig office, for turning us on to mysqltuner.pl.

The tool helped us immediately diagnose the following issues on one of our top e-commerce sites:

[!!] Maximum possible memory usage
[!!] Query cache prunes per day
[!!] Joins performed without indexes

2009 Zend Conference kick-off

I am in San Jose, CA, for the 2009 Zend Conference. Today is the Tutorials day. I attended the "Quality Assurance in PHP Projects". I wasn't very impressed. They glossed over Selenium and stumbled through the PHPUnit demo.

I'm now in the "PHP Code Review" tutorial. I thought it would be about how to perform code reviews, but instead the speakers are picking apart the code in Open Source PHP projects. Not sure how much value I'll be getting out of this.