Your right - I created a temp database to test, and the innodb engine shows the same stats for that new database (with no tables, no rows) that it did for a database with tables and data.
I guess InnoDB keeps one set of stats for all databases. I guess I'm too used to Oracle, that tracks statistics per database, in system tables. It would still work if each database ran in a seperate installation of MySQL, but that doesn't seem to be the setup. David. ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "David Griffiths" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 10:00 PM Subject: Re: Usage Monitoring > 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]
