mysqlperformanceload-time

How to test speed a query without result in MySQL

I have queries that return thousands of results, is it posible to show only query time without actual results in MySQL console or from command line?

Solution

  • Use SET profiling = 1; at command prompt.

    Refer for more details

    It's not possible to get the execution time without getting result or getting sql executed.

    See why we can not get execution time without actual query execution