How to set mysqld.log size?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I'm experiencing some problems due to big '/var/log/mysqld.log' size
(199 Mbytes), and I'd like to know if there's any method to set this
file's maximum size.

Thank you very much.


Re: How to set mysqld.log size? wrote:
Quoted text here. Click to load it

Typically one does not want to simply limit the size of a log, because
that would cause new information to be lost, if the size limit is reached.

The customary solution is "log rotation".  Rename the old file
"something.log" to "something.log.old" or by date,
"something.log.20060529", and then allow a new file "something.log" to
start growing from size zero.


Bill K.

Site Timeline