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, processed 388,648,665 queries (420/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 a MySQL server?  Thanks for any info!
 >	- John
--

---
John May : President  
Point In Space Internet Solutions [EMAIL PROTECTED]
 LPA Corporate Partner / FSA Associate / ACN Member

  Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Usage Monitoring

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

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

Re: Usage Monitoring

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

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: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!
> <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
>
> MySQL 4.0.15-Yahoo-SMP: up 10 days, processed 353,026,055 queries
(403/sec. avg)
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[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!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 10 days, processed 353,026,055 queries (403/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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
>
> --
>
> ---
> John May : President  
> Point In Space Internet Solutions [EMAIL PROTECTED]
>
>   LPA Corporate Partner / FSA Associate / ACN Member
>
>Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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  
> Point In Space Internet Solutions [EMAIL PROTECTED]
>
>  LPA Corporate Partner / FSA Associate / ACN Member
>
>   Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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  
Point In Space Internet Solutions [EMAIL PROTECTED]
 LPA Corporate Partner / FSA Associate / ACN Member

  Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]