How can I ONLY get the query execution time on the command line without waiting till the data 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