What is the best way to monitor activity on each database of my server ?
I tried mtop/mytop which display activity in real time but aren't very practical to see all the queries executed on it.
I activated MySQL logs but there's no option to split them per database.
What tools are you using to monitor MySQL servers ?
Best Answer
I try to stay away from having multiple databases in one instance. Instead I have multiple instances set up on a server where each one is dedicated to a database.
MySQL Cacti templates are a good monitoring solution. If you are enterprise customer then MySQL Enterprise Monitor works. Also check out mycheckpoint from openark.
EDIT
Here are some tutorials for setting up multiple instances on one server:
You could also use MySQL Sandbox as it automates a lot of different set ups for you.