On Fri, Oct 03, 2003 at 08:29:17AM -0400, John Murtari wrote: > 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.
Can't easily do that today, since MySQL doesn't track many per-db stats. > 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? Really? There are some per-user limits: http://www.mysql.com/doc/en/GRANT.html But I may have missed per-db limits. Where are they documented? > 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). Indeed, that's an ugly 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. That would be excellent. :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 19 days, processed 715,556,051 queries (418/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
