Matt W wrote:
Hi Patrick,
No, you can't get per database statistics in MySQL. :-(
May be there is a tool to get this information examining log file, or hooking requests send by clients??? By the way, it is possible to rotate log files?
Turn on full logging (log option), then write a few lines of Perl to parse it and collect the stats. Note that you could have cross-database queries.
To rotate, move the log into a different location, then do FLUSH LOGS
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
