The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Who uses mysql?

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

  1. mmx38

    mmx38 Member

    Joined:
    Apr 28, 2010
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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,623
    Likes Received:
    21
    Trophy Points:
    38
    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
     
Loading...

Share This Page