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 ?

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.