Re: poor performance on good hardware
> I want to make slow log rotate with newsyslog.
> Then it rotate log, it's sent SIGHUP to mysqld. Is
> it safely to rotate log this way? It's will be
> rotate once a 24 hours. If not, can you tell me
> any other and more safely method?
There is a bug in 5.1.3X that causes a crash in some situations when mysqld receives sighup. I wouldn't recommend doing that even though your version may have been fixed. 'FLUSH LOGS' is safe, however.
It is also safe to rename the slow log file (or any log file) prior to flush. Flush does not "notice the file is gone" but just reopens it, creating it if it does not exist.
Subject
Views
Written By
Posted
3653
December 02, 2009 08:36AM
2012
December 02, 2009 10:13PM
1796
December 03, 2009 02:17AM
1742
December 03, 2009 02:18AM
2320
December 08, 2009 03:42AM
1699
December 08, 2009 08:30PM
2877
December 09, 2009 05:42AM
2118
December 09, 2009 08:28PM
1897
December 10, 2009 11:10AM
1888
December 10, 2009 10:39PM
Re: poor performance on good hardware
1846
December 11, 2009 10:43AM
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.