For as long as I’ve been working on websites that require MySQL databases, I’ve been working with phpMyAdmin. It does what I need it to do, and I probably only use a quarter of what it offers. I had noticed a year or two ago that the new version of phpMyAdmin was quite a bit different than what I was used to, and had resisted adopting the new version for as long as possible. Unfortunately, I’m now using the dreadful version 3.5.7.
Category: MySQL
Enable General and Slow Query Logging
As I work with applications that use a MySQL database, I have various ways to check my actual queries, but MySQL makes it really easy to log queries and slow queries. Since my dev machine is 64-bit Windows 7, and I’m running XAMPP 1.8.0, I just needed to add a few lines to MySQL’s my.ini file, and turn the query logging on in phpMyAdmin.
UPDATE: Since adding XAMPP 1.8.3, slight changes have been necessary. See details at end of post.