Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Monitor resource usage per user

Discussion in 'Workarounds and Optimization' started by behinam, May 10, 2019.

  1. behinam

    behinam Active Member

    Joined:
    May 9, 2017
    Messages:
    40
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Dubay
    cPanel Access Level:
    Root Administrator
    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.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,160
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. behinam

    behinam Active Member

    Joined:
    May 9, 2017
    Messages:
    40
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Dubay
    cPanel Access Level:
    Root Administrator
    the command that you said, not to show the CPU usage per linux user in MySQL
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,160
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 MySQL Governor. I'll leave this thread open for additional user-feedback, but you may need to consult with a system administrator or developer to determine how to best evaluate MySQL usage on a per-user basis without using a third-party plugin. We provide a list of companies offering system administration services on the link below:

    System Administration Services | cPanel Forums

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice