From mboxrd@z Thu Jan 1 00:00:00 1970 From: "David Jackson" Subject: Re: Rotating mysqld.log Date: Mon, 10 Jun 2002 08:13:02 -0600 Sender: linux-admin-owner@vger.kernel.org Message-ID: <200206100813.AA1141113094@wcox.com> Reply-To: Mime-Version: 1.0 Return-path: List-Id: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To: linux-admin@vger.kernel.org, Ramasubramanian 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