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 ‘query_cache%’; The following options may assist in resolving these issues: Adding […]