I'm using MySQL v5.5 and we have 6 databases in same Mysql. We are planning to move some databases to separate servers. For that I need to know resource usages of each databases. I have checked process using show processlist, but I need to calculate at least usage in 24hr time frame.
Is that possible to check Resource usage (cpu/ram) of each Dbs ? Is there any way to analysis total resource usage of queries to each db ?