Re: Usage Monitoring

2003-09-24 Thread John May
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

Re: Usage Monitoring

2003-09-24 Thread Jeremy Zawodny
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,

Usage Monitoring

2003-09-23 Thread John May
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

Re: Usage Monitoring

2003-09-23 Thread daniel
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

Re: Usage Monitoring

2003-09-23 Thread colbey
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 --

Re: Usage Monitoring

2003-09-23 Thread Jeremy Zawodny
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!

Re: Usage Monitoring

2003-09-23 Thread David Griffiths
, 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

Re: Usage Monitoring

2003-09-23 Thread Jeremy Zawodny
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

Re: Usage Monitoring

2003-09-23 Thread David Griffiths
: 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