470,614 Members | 1,438 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

How to set mysqld.log size?

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

May 29 '06 #1
1 11408
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.
May 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Stephane Raimbault | last post: by
reply views Thread by Maciej Wiznerowicz | last post: by
reply views Thread by Robert Morgan | last post: by
reply views Thread by Robert Morgan | last post: by
reply views Thread by Gary Cote | last post: by
3 posts views Thread by Paul | last post: by
1 post views Thread by Jeremy Kohansimeh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.