If you need to optimize or find out how a MySQL query is doing, type in “EXPLAIN” before the query and you’ll get a table that shows a bunch of statistics. I’m not going to try to explain them all. It can be found on the MySQL docs site:
A Log of Coding Solutions