Skip navigation links

MySQL Forums :: Newbie :: how to configure slow log


Advanced Search

Re: how to configure slow log
Posted by: Rick James ()
Date: April 26, 2012 08:53PM

No such feature exists.

Plan A: Live with it.

Plan B: Write a cron job that modifies my.cnf (my.ini) and restarts the server so that it will take effect. Another cron job undoes it.

Plan C: Put the code for Plan B around the call to mysqldump.

Plan D: http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_log-slow-queries Note that log_slow_queries or slow_query_log is "Dynamic". That is, you could turn it off around the dump. (Caution: be sure to read the doc page for the version you have.) You can do that on a commandline something like
mysql -u root -p... -e "slow_query_log=0"

Options: ReplyQuote


Subject Written By Posted
how to configure slow log 04/25/2012 02:33AM
Re: how to configure slow log Rick James 04/26/2012 08:53PM
Re: how to configure slow log 04/27/2012 02:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.