Hi all, I'd like to be able to analyse the log files that my MySQL server produces. Basically, I want to find out how many logins every account is doing, how many queries are being performed against each database (although not necessarily per-table) and how many slow queries each account is doing. All of these figures I want to be able to quantify against a certain time period - for example, a 24-hour period. Does anyone know of any log reporting software that might be able to do the job? Maybe somebody has already written something themselves? Initially I thought of using Analog (which I already use for my web, FTP and RealServer logs), but even that's not customisable to the extent I need. Something like Webalizer would be great (with its graphing), but that too is tailored for web logs. Ideally, it'd be great to get MySQL logging to another MySQL database - which I could then use PHP for to query and generate reports, but that seems slightly silly and a bit overkill... :) Also, I notice that the slow query log doesn't record which database was being queried (I'm using version 3.23.32). Why not? Surely this is an essential bit of info? Regards, ------------------------------------------------ Basil Hussain ([EMAIL PROTECTED]) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
