From: Yves Goergen (nospam.listunclassified.de)
Date: Sun Jul 20 2008 - 15:33:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,

I've installed MySQL server 5.0 and have written a small statistics
script that regularly checks the number of connections and queries to
the server, which I can then view in a diagram. But sometimes it just
says that at a time, unusually many connections or queries have been
made to the server. I cannot see what causes them. Neither the user nor
the actual queries.

At work I got in touch with the Oracle Enterprise Manager recently. I
haven't looked at it too closely yet, but I think it could give useful
information about each session, what it does and more importantly what
it did.

I have no idea what to search for to get this information from the MySQL
server. So I had to ask here first. Is there any method to get those
statistics? I don't mean the SHOW PROCESSES list, it only contains a
snapshot of the very moment when MySQL got to execute my command. I mean
information about recent activity, like 15 minutes, 2 hours or so.

--
Yves Goergen "LonelyPixel" <nospam.listunclassified.de>
Visit my web laboratory at http://beta.unclassified.de

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]