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]
