Basic MySQL troubleshooting guide

If a query has frozen up the MySQL server, you can see the troublesome query by running the following command (works in phpMyAdmin too) show processlist; you can also see the cache and allocation of the server by the following command: SHOW VARIABLES LIKE...