MySQL Forums
Forum List  »  Newbie

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
April 25, 2012 02:33AM
Re: how to configure slow log
April 26, 2012 08:53PM
April 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.