Will this show usage per-database, or only for the server overall?
- John
Might try mytop (search google for it) .. jeremy z wrote it.. it works
well for realtime monitoring..
On Tue, 23 Sep 2003, John May wrote:
Is there any way to monitor which databases are being used the most
heavily on
On Wed, Sep 24, 2003 at 09:54:12AM -0400, John May wrote:
Will this show usage per-database, or only for the server overall?
Overall.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 10 days,
Is there any way to monitor which databases are being used the most
heavily on a MySQL server? Thanks for any info!
- John
--
---
John May : President http://www.pointinspace.com
Point In Space Internet
Mytop ?
Is there any way to monitor which databases are being used the most
heavily on a MySQL server? Thanks for any info!
- John
--
---
John May : President http://www.pointinspace.com
Point In
Might try mytop (search google for it) .. jeremy z wrote it.. it works
well for realtime monitoring..
On Tue, 23 Sep 2003, 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!
- John
--
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!
, 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: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
: 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