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"
Subject
Written By
Posted
Re: how to configure slow log
April 26, 2012 08:53PM
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.