How to set mysqld.log size?

[francescomoi]

Hi.

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.

--f

[Bill Karwin]

fr**********@usa.com wrote:

Hi.

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.

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.

See:
http://dev.mysql.com/doc/refman/5.0/...intenance.html

Regards,
Bill K.