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 wrote: > 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
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
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 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
Greetings. Try with the variable innodb_status_file. I wont get logged in mysqlerr.log file. On 17 March 2010 15:15, Shanmugam, Dhandapani 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
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