Re: Gaining statistics from MySQL

[Alex Greg]

On 2/20/07, Clyde Lewis [EMAIL PROTECTED] wrote:

I'm looking to find a way to determine the number of transactions
that a particular database is processing each min/hour/day/month/year


http://dev.mysql.com/doc/refman/4.1/en/show-status.html

http://dev.mysql.com/doc/refman/4.1/en/server-status-variables.html

Looks like Com_commit is what you're looking for (though you can
replace commit with most other types of query, i.e. Com_select,
Com_insert...).

This is a counter, so you'll need to record the value periodically and
work out the differences for a period.


-- Alex

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

Gaining statistics from MySQL

[Clyde Lewis]

I'm looking to find a way to determine the number of transactions 
that a particular database is processing each min/hour/day/month/year 
and would like to know of a known MySQL best practices for 
determining this information. I'm hoping that this can be determined 
at the database level, but am not currently aware of how to move for forward.


Release: 4.1.20
OS: Solaris 10

Thanks in advance,

***
Clyde Lewis
Database Administrator
General Parts, Inc.
919-227-5100


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