|
|
|
|
| CA | BD | NY |
Apache Hacker CentOS Hacker miniCTOBackground
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 [...]
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 [...]
How to use mytop and ajaxMyTop to monitor mysql processes.
How to debug MySQL queries using SHOW FULL PROCESSLIST and a comment trick.
