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