Folks,
I've done a lot of searches, tried out the tools I could
find (like phpMyAdmin/mtop). We have a server with about 30 DB's
and we would LOVE to get a report that gives us queries/hour, cpu,
etc.. against each DB so that we can measure activity.
We are running 4.0.13 on Redhat 7.2 -- we can see
some commands added to "limit" activity on a per DB basis. So I
assume there is some "counting" going on somewhere. Is there any
way to access those values?
Right now the only brute force method we have is to
turn on query logging for sample intervals and then count what we
see there (but it is a gross solution).
Does this exist somewhere? Are other adminstrators looking
for this type of info on a per BD basis? We have considered actually
contributing some engineering effort to get into the source code to
make such data available.
Best regards!
--
John
___________________________________________________________________
John Murtari Software Workshop Inc.
[EMAIL PROTECTED] 315.695.1301(x-211) "TheBook.Com" (TM)
http://www.thebook.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
