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 »