title: how to clear/flush mysql innodb buffer pool?
body: <p>I'm perf tuning a large query, and want to run it from the same baseline before and after, for comparison.</p>
  
  <p>I know about the mysql query cache, but its not relevant to me, since the 2 queries would not be cached anyway.</p>
  
  <p>What is being cached, is the innodb pages, in the buffer pool.
  Is there a way to clear the entire buffer pool so I can compare the two queries from the same starting point?</p>
  
  <p>Whilst restarting the mysql server after running each query would no doubt work, Id like to avoid this if possible</p>