What is the equivalent in MySql for STATISTICS IO?

Question

When I do a query on MSSQL, I can issue these statements to get statistics on time and IO returned with the query.

SET STATISTICS IO ON;
SET STATISTICS TIME ON;

They are a good first look indicator for the performance of the query. Does something like this exist in MySql and how do I enable it ?

Answer 1

I am not sure what SET STATISTICS does in MSSQL, but you are probably looking for the SHOW PROFILE and SHOW PROFILES commands.