--00163630eef9cbdd120481fbc24f
Content-Type: text/plain; charset=ISO-8859-1
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
--00163630eef9cbdd120481fbc24f--
anand=20
Do you use innodb engine at all further
-D
-----Original Message-----
From: sanand84@gmail.com [mailto:sanand84@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=3Dgcdmg-mysql-2@m.gmane.o rg
--00504501701dea56150481fc1ae8
Content-Type: text/plain; charset=ISO-8859-1
Greetings.
Try with the variable innodb_status_file.
I wont get logged in mysqlerr.log file.
On 17 March 2010 15:15, Shanmugam, Dhandapani
> anand
>
> Do you use innodb engine at all further
> -D
>
> -----Original Message-----
> From: sanand84@gmail.com [mailto:sanand84@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=ramesh4f@gmail.com
>
>
--
Ramesh
--00504501701dea56150481fc1ae8--
--000e0cd630a089c0200481fc5356
Content-Type: text/plain; charset=ISO-8859-1
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
> 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.shanmugam@eds.com> wrote:
>
>> anand
>>
>> Do you use innodb engine at all further
>> -D
>>
>> -----Original Message-----
>> From: sanand84@gmail.com [mailto:sanand84@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=ramesh4f@gmail.com
>>
>>
>
>
> --
> Ramesh
>
--000e0cd630a089c0200481fc5356--
--Apple-Mail-1-608294977
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed
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
--Apple-Mail-1-608294977--
--00163630eca9da8a590481fdf099
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
>
>
--00163630eca9da8a590481fdf099--