If you're using InnoDB, then that's not exactly true. >From the msql client, you can type "show innodb status" and you'll get a bunch of stats on the database, which include:
-------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue Main thread process no. 5741, id 2653731264, state: waiting for server activity Number of rows inserted 9179949, updated 0, deleted 978603, read 17626950 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Our database is pretty quiet right now - doing testing, and have left it for a few days, but if your database is active, capturing this a few times per day to a log file might give some insight on how busy it is. David. ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "John May" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 8:27 PM Subject: Re: Usage Monitoring > On Tue, Sep 23, 2003 at 09:30:14PM -0400, John May wrote: > > Is there any way to monitor which databases are being used the most > > heavily on a MySQL server? Thanks for any info! > > No. MySQL doesn't keep per-database statistics. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.15-Yahoo-SMP: up 10 days, processed 353,026,055 queries (403/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
