Skip to content
Advertisement

How to know what the select query took time?

I have 4 queries and I want to compare the time between them, Is there any command to show the time taken for every query?

Advertisement

Answer

You have can use SHOW PROFILE Statement.

Enable it by using:

For example, I executed some queries as below:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement