Enabling the MySQL general log

Enabling the general query log in MySQL lets you see what mysqld is up to. For example when clients connect or disconnect and any SQL statements »

How to find out what MySQL is actually doing

Explain is a great tool for looking into the strategy chosen by the query optimizer for executing the query but you have to bear in mind »