On Tue, Sep 23, 2003 at 09:12:46PM -0700, David Griffiths wrote: > 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.
Eh? I see no per-database stats in that output. Jeremy -- 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,782,776 queries (401/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
