i need to log three databases and what queries are been sent to them their changes etc, ideally whats happening at that particular time.
either the general or slow query logs using grep and or limited/filtered logging and then perhaps mysql-log-filter - Google Code (or similar). Can be a pita if it's a shared box, especially if you're not looking for a specific problem/issue.
As PipeTen mentioned - mtop is good, you can also use the free mysql administrator tools on windows that will show you the "show processlist;" so you could just refresh it when needed.
__________________ » Sean Andrews,
» xoozoo.com ltd - www.xoozoo.com
» Free DNS Report tools - dr.xoozoo.com
» Company no:6482396
The other option of course is binlogs, download them, process them to your hearts content - providing you're not after something realtime, but combined with the mySQL windows admin tool, can be very useful.
__________________ Karl Austin :: Owner :: Director :: Admin :: Tea Boy KDA Web Services Ltd. :: 0800 542 9764 :: Company: 04114724 :: VAT: GB 842 9597 81 "Individual Solutions for Individual Customers" - Call us today for free
I tried monyog but didnt really help. I have a server i got set up with works alongside with a mysql database which i want to see what data is going in and out of the three databases that are inside,
I've tried using mysqldump aswell but that didnt seem. I found you can get it to do xml output but couldnt find how to output into an actual xml file.
