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, proc

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-23 Thread 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

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 > ---

Re: Usage Monitoring

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

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 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 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 > P