MySQL Profiling
MySQL allows you to profile queries, enabling you to see whats being run on your server. They are stored in a special profile table in the INFORMATION_SCHEMA database. You can…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
MySQL allows you to profile queries, enabling you to see whats being run on your server. They are stored in a special profile table in the INFORMATION_SCHEMA database. You can…
If like me you need to check out the PHP error log, but its bloody massive, you might want to take the last few lines of it. tail -x log_file…
I often set up mysql query logging when I am diagnosing a problem. In the my.cnf file, enter (or update the log parameter) log=/path/to/logfile.log Remember to restart the mysql service:…