Archive for the PHP Category
Published June 26th, 2009
Recently, I was helping a co-worker debug a MySrQL issue with an old app that started breaking after the dev team switched the app’s textareas to TinyMCE editor. Typically, for quick-and-dirty debugging sessions that we want to wrap in minutes, we use a simple dumpQuery() function in PHP that prints out any query used in [...]
Published December 13th, 2008
Understanding MySQL Query Cache for PHP Developers
Published November 9th, 2008
How to use MySQL directives to enhance your query performance
Published November 8th, 2008
How to use mytop and ajaxMyTop to monitor mysql processes.
Published October 31st, 2008
Why MySQL VIEW filtering (i.e. applying WHERE clause) might be a bad for performance.
Published October 30th, 2008
How to debug MySQL queries using SHOW FULL PROCESSLIST and a comment trick.
