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" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
