Monitor resource usage per user

behinam

• May 10, 2019 05:28

Hello 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. i want monitor mysql usage per user and i don't want use ClounLinux for this purpose.

• 

  cPanelMichael

  • May 10, 2019 22:14

  Hello @behinam, Have you tried using the "mysqladmin processlist" command? Here's the corresponding documentation on this utility: MySQL :: MySQL 5.7 Reference Manual :: 13.7.5.29 SHOW PROCESSLIST Syntax mysqladmin Thank you.

  0
• 

  behinam

  • May 11, 2019 04:59

  the command that you said, not to show the CPU usage per linux user in MySQL

  0
• 

  cPanelMichael

  • May 15, 2019 17:45

  Hello @behinam, I'm not aware of a specific command or step-by-step guide to mimic the functionality of a third-party application such as System Administration Services | cPanel Forums Thank you.

  0

Please sign in to leave a comment.