I want to know is there anyway to get CPU usage per user in MySQL? for example I have 3 different users 'user1', 'user2' and 'user3'. I want to get the average/real time memory usage and CPU usage of these users.I googled a lot but I did not find any suitable tool. Maybe I can get these data from MySQL queries, but I don't know where are they stored.

closed as unclear what you're asking by Rui F Ribeiro, Fabby, Jeff Schaller May 12 at 16:37

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • I'm voting to close this question as off-topic because this belongs on Database Administrators – Fabby May 12 at 12:46
  • Are these MySQL users or OS users? Are you looking for the OS cpu usage or usage within MySQL? – Jeff Schaller May 12 at 16:37
  • i want OS user CPU usage in Percentage or Frequency. – behnam bahadori May 13 at 6:13

From a *nix perspective, you can only get the mysql user statistics so basically what all users of MySQL are doing on the system.

To get individual Database User Statistics, you need to dig into the MySQL documentation or take this question to https://dba.stackexchange.com.

Not the answer you're looking for? Browse other questions tagged or ask your own question.