What is the equivalent in MySql for STATISTICS IO?
mysql, sql, sql-server
Solution
I am not sure what `SET STATISTICS` does in MSSQL, but you are probably looking for the `SHOW PROFILE` and `SHOW PROFILES` commands.
Problem
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 ?