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!

Who uses mysql?

Discussion in 'Database Discussion' started by mmx38, Apr 5, 2012.

  1. mmx38

    mmx38 Member

    Joined:
    Apr 28, 2010
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Hello!

    I noticed that mysql makes high usage of cpu..

    Is there any way to know which accounts/users are using the mysql?


    Thank you!
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Yes, you can check WHM > Daily Process Logs for MySQL activity by set users.

    You can run mysqladmin proc to check the currently running processes (or watch -n 5 "mysqladmin proc" to have a time delay refresh of it).

    You could enable the general and slow query logs as well. We don't have the information on what MySQL version you are using to provide more input on that. You can find out your MySQL version by running this command:

    Code:
    mysql_config --version
     
    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