Saturday, August 7, 2010

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:

Tuesday, March 2, 2010

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

Wednesday, February 10, 2010

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

Friday, January 8, 2010

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

Monday, November 2, 2009

"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.

Tuesday, October 27, 2009

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

Monday, October 19, 2009

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.