RE: Disable innodb status info in err log
anand Do you use innodb engine at all further -D -Original Message- From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand Sent: Wednesday, March 17, 2010 3:00 PM To: mysql@lists.mysql.com Subject: Disable innodb status info in err log Hi All, Innodb status information is getting logged on to my mysql error log file for every 15 seconds, can someone help in disabling it ? Thanks Anand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Disable innodb status info in err log
Greetings. Try with the variable innodb_status_file. I wont get logged in mysqlerr.log file. On 17 March 2010 15:15, Shanmugam, Dhandapani dhandapani.shanmu...@eds.comwrote: anand Do you use innodb engine at all further -D -Original Message- From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand Sent: Wednesday, March 17, 2010 3:00 PM To: mysql@lists.mysql.com Subject: Disable innodb status info in err log Hi All, Innodb status information is getting logged on to my mysql error log file for every 15 seconds, can someone help in disabling it ? Thanks Anand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=rames...@gmail.com -- Ramesh
Re: Disable innodb status info in err log
you are right sir , the variables innodb_status_file will write the show innodb status information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how to stop it from writing... Any help would be appreciated Thanks Anand On Wed, Mar 17, 2010 at 3:24 PM, RaMeSh rames...@gmail.com wrote: Greetings. Try with the variable innodb_status_file. I wont get logged in mysqlerr.log file. On 17 March 2010 15:15, Shanmugam, Dhandapani dhandapani.shanmu...@eds.com wrote: anand Do you use innodb engine at all further -D -Original Message- From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand Sent: Wednesday, March 17, 2010 3:00 PM To: mysql@lists.mysql.com Subject: Disable innodb status info in err log Hi All, Innodb status information is getting logged on to my mysql error log file for every 15 seconds, can someone help in disabling it ? Thanks Anand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=rames...@gmail.com -- Ramesh
Re: Disable innodb status info in err log
On 17/03/2010, at 9:10 PM, Anand kumar wrote: you are right sir , the variables innodb_status_file will write the show innodb status information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how to stop it from writing... Any help would be appreciated Do you happen to have a table called innodb_monitor? If that is present, then that will cause the result of SHOW ENGINE INNODB STATUS to be outputted every 15 seconds. See also http://dev.mysql.com/doc/ refman/5.0/en/innodb-monitors.html or http://dev.mysql.com/doc/refman/ 5.1/en/innodb-monitors.html Cheers, Jesper
Re: Disable innodb status info in err log
Jesper, I dont have a table called innodb_monitor on any of my databases, i gone through the links which you mentioned here.. but no luck.. Thanks Anand S On Wed, Mar 17, 2010 at 5:06 PM, Jesper Wisborg Krogh jes...@noggin.com.auwrote: On 17/03/2010, at 9:10 PM, Anand kumar wrote: you are right sir , the variables innodb_status_file will write the show innodb status information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how to stop it from writing... Any help would be appreciated Do you happen to have a table called innodb_monitor? If that is present, then that will cause the result of SHOW ENGINE INNODB STATUS to be outputted every 15 seconds. See also http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html or http://dev.mysql.com/doc/refman/5.1/en/innodb-monitors.html Cheers, Jesper