How can I ONLY get the query execution time on the command line without waiting till the data is displayed? I am testing and comparing execution times of queries with big result sets using the command line. 

It takes too long to display the result set! Is there any way to see only the query execution time without waiting till all of the result set is displayed?
Solution for Getting only Execution time of Query without printing result set : 

Query :Select C1 , C2, C3 from Table where C3='1'; -- 40571 rows in set (0.079 sec)


Get Count of query : 

Do : Select count(*) from (Select C1 , C2, C3 from Table where C3='1') as X;

Time : 0.035 sec 
Redirecting output to /dev/null : 

Do : time mysql  -u'user' -p'password' Database &lt; query.sql &gt; /dev/null

Time : 


    real    0m0.180s
    user    0m0.112s
    sys     0m0.005s



Using mysqlslap : 

Do : 


vi query1.sql                   // Addin the query.
mysqlslap   -u'user' -p'password' --query="query1.sql"  --delimiter=";" --concurrency=1 &gt;&gt; output.log


Time : 
mysqlslap: [Warning] Using a password on the command line interface can be insecure.
Benchmark
    Average number of seconds to run all queries: 0.080 seconds
    Minimum number of seconds to run all queries: 0.080 seconds
    Maximum number of seconds to run all queries: 0.080 seconds
    Number of clients running queries: 1
    Average number of queries per client: 1


According to me ideal is 3rd solution using mysqlslap