title: Why are queries executed from mysql workbench taking much longer than executing them directly from the mysql cli?
body: <p>I have a query that does multiple joins on several tables and uses a covering index.  It seems to run a lot faster when executed directly from the mysql cli instead of from mysql workbench.</p>
  
  <pre><code>mysql &gt; some query
  ...
  250 rows in set (0.05 sec)
  </code></pre>
  
  <p>from mysql workbench it takes about <code>~0.200 sec duration / 0.100 sec fetch</code></p>
  
  <p>Is there a reason beyond latency, authentication and transfer of data why it would be orders of magnitude faster on the console?  Does a three-way tcp handshake occur each time a query is executed from mysql workbench or does that tcp connection stay open until you close the workbench session?</p>