Rotating mysqld.log

Rotating mysqld.log

[Ramasubramanian]

Hi All,

	I have a RH-7.2 server running mysql 3.23.41-1. I need to rotate
        the mysqld.log based on some size criteria. I have a config file
        as follows :

	mysqlrotparams.conf
        *******************

	"/var/log/mysqld.log" {
		rotate 5
		size=100k
		missingok
		create 0644 mysql mysql
	}

	I have configured a cron entry to execute this every one minute as
	follows.

	*/1 * * * *	/usr/sbin/logrotate -v mysqlrotparams.conf

	I increased the size of mysqld.log to 1200k but rotation didn't
        happen. The following was the output


        reading config file /root/mysqlrotparams.conf
	reading config info for "/var/log/mysqld.log"
	Handling 1 logs
	rotating pattern: "/var/log/mysqld.log"  102400 bytes (5 rotations)
	empty log files are rotated old logs mailed to rams@nmsworks.co.in
	rotating file /var/log/mysqld.log
	log does not need rotating


	Can anyone help me in this regard ???

	Thanks in advance.


Regards
Rams



-- 

Re: Rotating mysqld.log

[David Jackson]

Rams --

One of the keys  to getting you question answered quickly is posting to the
forum that most closing deals with you issue, as well as searching threw
the documentation. In this case your taking about MySQL, here's some
links the will help you:

Are you using the mysql log rotate sciipt that comes with mysql? 
find / -name mysql-log-rotate


MySQL mailing list:
http://mysql.com/documentation/lists.html

MySQL searchable documentation:
http://mysql.com/doc

Log file maintence :
http://www.mysql.com/doc/L/o/Log_file_maintenance.html

Your might want to consider doing a rotate once a day, compressing it
backing it up and removing it depending on the size. 


HTH,
David