How to find the total connections for a 24 hr. period ?
I have MySQL 4.0.20. I'm collectioning stats and I'd like to break out the number of "Questions" to the database in a 24 hr. period. I'd like to collect these stats so when I get a lot of say, Aborted Connections I can see how many there are in relation to the number of connections.
I get the Aborted Connections from mysqld.log. I get slow queries from the slow_queries_log. Any hints on where to get the questions iinfo that can be broken down by 24 hr. period/date?
On another note I've got mysqlreport running which is totally cool for giving me human understandable performance stats. Seems I'm using my key_buffer well and I can even tweak it a bit bigger. very cool tool.
thanks,
erin
Subject
Views
Written By
Posted
How to find the total connections for a 24 hr. period ?
3157
August 17, 2005 11:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.