How stop 'show innodb status'

SAbboushi
SAbboushi used Ask the Experts™
on
I have disabled InnoDB (unchecked the 'Activate InnoDB' in MySQL Administrator, Startup Variables, InnoDB Parameters).

So why is my query log showing the following entries created once a second, and how do I stop the queries from happening while MySQL Service is running?  
100128  6:42:07          6 Query      SHOW GLOBAL STATUS
                6 Query      SHOW INNODB STATUS

MySQL 5.1 Single user environment running under Vista64.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi

do you have any MySQL managing software open, running in the tray for instance?
Like MySQL Administrator or MySQL Workbench, or anything else that could be polling the server?
there must be table called innodb_monitor with your mysql default database...try droping that table

DROP TABLE innodb_monitor;

http://dev.mysql.com/doc/refman/5.1/en/innodb-monitors.html

thanks

Kalpan

Author

Commented:
>>do you have any MySQL managing software open, running in the tray for instance?
Like MySQL Administrator or MySQL Workbench, or anything else that could be polling the server?

I have MySQL Administrator and MySQL Query Browser running

>> there must be table called innodb_monitor with your mysql default database
Not that I can find...
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Commented:
Try shutting down MySQL Administrator for a while and check the log afterwards for that time period.
I get that query/sec behavior only with MySQL Admin open - especially if I'm on the Server Health tabs
Commented:
Mind you - once you get into the Health pages in MySQL Administrator and the application starts plotting the graphs, it doesn't stop until you close it. If you open it up and never get to Health, it will never poll the server.  If you open it once, it will keep polling until you close the application. I worded it wrongly before.
On a sidenote, the latest MySQL Workbench beta has almost the same functionality as Administrator (along with other great stuff) and does not show the same behaviour - it only sends "show global status". On the other hand, it doesn't have as many graphs.

Author

Commented:
Thanks - that was it!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial