title: Get time for MySQL result without showing result
body: <p>I realized that using phpMyAdmin for testing the speed of queries might be dumb: it automatically applies a <code>LIMIT</code> clause.</p>
  
  <p>I tried a certain query on a fairly large number of records (31,595) with a <code>GROUP BY</code> clause. phpMyAdmin, adding <code>LIMIT 0, 200</code>, took 0.1556 seconds to fetch the results.</p>
  
  <p>I decided to try the same query from the command line without the <code>LIMIT</code> clause and it took 0.20 seconds. Great, so now I have the real time it takes for that query.</p>
  
  <p>But the downside is I had to wait for 30,000+ records to print on the screen.</p>
  
  <p>Is there a better solution?</p>
  
  <p>EDIT:
  To clarify, I am looking for a way to suppress the screen output of a select query while still getting an accurate time for running the query. And I want it to be something that could be typed in and timed at any time (i.e. I don't want to have to tweak <code>slow log</code> settings to capture results).</p>