![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| Hi all, I'm running mysql 4.0.20 (on a Mandrake 10.1 Linux) installed from an RPM. I'm trying to stop the innodb monitor writing a status file every 15 seconds or so (so my disk can spin down). According to this page: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html I can stop the monitor by dropping the innodb_monitor table with: DROP TABLE innodb_monitor; This doesn't work! I'm not sure if I should expect to see the table with SHOW but I don't: mysql> use mysql Database changed mysql> show tables; +-----------------+ | Tables_in_mysql | +-----------------+ | columns_priv | | db | | func | | host | | tables_priv | | user | +-----------------+ 6 rows in set (0.00 sec) mysql> DROP TABLE innodb_monitor; ERROR 1051: Unknown table 'innodb_monitor' Not really surprising that it doesn't work! Still, I get files like: /var/lib/mysql/innodb.status.4354 updated every 15 seconds with the similar output you get when issuing the command: mysql> SHOW INNODB STATUS\G Any ideas anyone? I get the feeling I'm missing something very simple? Many thanks, Justin | |||
|
| Featured Websites | ||||
|
![]() |
| Tags: innodb, monitor, stopping |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Monitor icc profiles | Timo Autiokari | Graphics in general | 3 | 05-31-2007 5:33 PM |
| Stopping a buyer bidding???? | mindesign | Ebay Technical Questions | 0 | 05-31-2007 12:19 PM |
| need driver for monitor | Betina & Morten | Operating Systems And Software | 1 | 05-28-2007 4:49 PM |
| Stopping Spam what do you do? | MadKad | Community Chat | 11 | 01-09-2007 7:42 PM |
| Monitor Filters | rjames | Computer Accessories | 5 | 07-31-2006 3:11 AM |
| Featured Websites | ||||
|