title: mysql-slow.log how to find specific query SELECT /*!40001 SQL_NO_CACHE */ * FROM
body: <p>Running this command:</p>
  
  <pre><code>mysqldumpslow -a -s r -t 30 /var/lib/mysql/mysql-slow.log
  </code></pre>
  
  <p>Gives me this:</p>
  
  <pre><code>Count: 1  Time=1346.85s (1346s)  Lock=0.00s (0s)  
  Rows_sent=237930890.0 (237930890), Rows_examined=237930890.0 
  (237930890), Rows_affected=0.0 (0), user[user]@localhost
  SELECT /*!40001 SQL_NO_CACHE */ * FROM `sometable`
  </code></pre>
  
  <p><strong>My goal is to find the slow query and fix it</strong>.</p>
  
  <p>I have searched for "* FROM <code>sometable</code>", "40001", "SQL_NO_CACHE", none of those are found in the source code.  Whats the deal?  All other queries, I can find no problem.</p>
  
  <p>I realize that the count is 1.  That is because this is a relatively new log, the count will go up.</p>