MySQL Forums
Forum List  »  InnoDB

Re: Log files filling up
Posted by: Rick James
Date: November 24, 2012 03:57PM

Which "log files"?

The general log should not be left on for long.

The slowlog will continue to grow; you should review it and fix the slow queries.

The iblog files (usually 2 of them) do not grow. They are written "circularly".

mysqld.err normally does not grow much. If it does, then there is some issue to deal with.

mysql.log only records start/stop; are you starting/stopping too much?

The binlog will grow to 1GB (based on a setting), then start another one. See expire_logs_days.

The "relay logs" show up on Slaves. They are automatically purged, unless replication is stuck. See SHOW SLAVE STATUS.

Did I miss any logs?

Options: ReplyQuote


Subject
Views
Written By
Posted
2091
November 23, 2012 01:12PM
Re: Log files filling up
1011
November 24, 2012 03:57PM


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.