Archive for the Debugging Category
Published June 10th, 2010
Background
One of our customer runs a large (in our camp at least) MySQL system with tables exceeding 30-50M records storing online transaction data. They use daily cron job to create data summary from these transaction tables which runs nightly and produces summary data on MEMORY tables for quick access by thousands of other companies to [...]
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 November 8th, 2008
How to use mytop and ajaxMyTop to monitor mysql processes.
Published October 30th, 2008
How to debug MySQL queries using SHOW FULL PROCESSLIST and a comment trick.