How to test speed a query without result in MySQL

load-time, mysql, performance

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

Problem

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?

Original source