Speed-testing a query? Flush your MySQL caches
Thanks to the MySQL Performance Blog for this tip:
RESET QUERY CACHE;
FLUSH TABLES;
SET GLOBAL key_buffer_size=0;
SET GLOBAL key_buffer_size=14691328;
No comments yet
Thanks to the MySQL Performance Blog for this tip:
RESET QUERY CACHE;
FLUSH TABLES;
SET GLOBAL key_buffer_size=0;
SET GLOBAL key_buffer_size=14691328;