How to speed up your MySQL queries 300 times

Posted by bob on May 2, 2017 1:38 AM EDT
Opensource.com
Mail this story
Print this story

Before you can profile slow queries, you need to find them. MySQL has a built-in slow query log. To use it, open the my.cnf file and set the slow_query_log variable to "On." Set long_query_time to the number of seconds that a query should take to be considered slow, say 0.2. Set slow_query_log_file to the path where you want to save the file. Then run your code and any query above the specified threshold will be added to that file. read more

Full Story

  Nav
» Read more about: Groups: MySQL; Story Type: News Story

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.