On Sun, Jul 20, 2008 at 1:33 PM, Yves Goergen <[EMAIL PROTECTED]> wrote: > 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.
Check out the general query log: http://dev.mysql.com/doc/refman/5.0/en/query-log.html -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
