Site Performance Optimization

After attending the Velocity Conference a couple months back, we have been focusing a lot of attention of optimizing our page rendering and load times.

Some tools we've started leveraging are:

• WebPageTest


• Show Slow


• HTTP Watch


• GTMetrix

mysqldumpslow

Just another post for me to be able to track down a command that comes in handy a lot.

mysqldumpslow -t 10 –s t /path/to/slow/log

Parse apache log for page requests that trigger 500 error

Posting this so I don't need to remember how to get this info.

To parse an apache log for the requests that are status code 500 (internal server error):

'cat /path/to/access/log/file' | awk '{print $7, $9}' | grep ' 500'

Provides output like:

/blah/xyz.php 500
/bleh/abc.php 500
/xxx/yyy.php 500

Capture Time to First Byte using curl

Posting this so I don't have to remember where to search for it.

http://www.pinoytux.com/linux/capture-time-to-first-byte-using-curl

"Googled: The End of the World as We Know It"

The chances of me ever finishing a book these days are nil. Therefore, I just bought the CD version of Googled: The End of the World as We Know It.

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.