Speed-testing a query? Flush your MySQL caches
Thanks to the MySQL Performance Blog for this tip:
RESET QUERY CACHE;<br />
FLUSH TABLES;<br />
SET GLOBAL key_buffer_size=0;<br />
SET GLOBAL key_buffer_size=14691328;
Written on July 28, 2009
Hello, I'm Jonathon Hill. I build things for the web.
Thanks to the MySQL Performance Blog for this tip:
RESET QUERY CACHE;<br />
FLUSH TABLES;<br />
SET GLOBAL key_buffer_size=0;<br />
SET GLOBAL key_buffer_size=14691328;