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!

high usage mysql + just for one user

Discussion in 'Database Discussion' started by morteza3245, Nov 17, 2013.

  1. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    138
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hello
    i see my mysql have much usage:
    when i did run "mysqladmin processlist;" i saw one user have much process:
    also in dbtop command i see:

    they are for one user.

    how i can see why have this usage? or how i can resolve that?

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 morteza3245, Nov 17, 2013
    Last edited: Nov 17, 2013
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,888
    Likes Received:
    90
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    If your only one user is increasing the load on your server through MySQL then you will have to optimize that user MySQL DB on your server
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. MikeDVB

    MikeDVB Well-Known Member
    PartnerNOC

    Joined:
    Jun 4, 2008
    Messages:
    218
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Indiana, USA
    Unless you manage the script the user is using and you wrote the MySQL queries they're executing there's very likely little you can do short of perhaps making sure your MySQL is optimized for your environment. You'd probably want to get in contact with the customer and advise them of their usage and ask them to optimize - if they can't do it, there's not really any way you could do it unless you want to update/manage their script for them.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    138
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Thanks
    how i can see slow queries?
    how i can kill a database ID when i run "mysqladmin processlist;"

    i did use kill -9 ID but dont work for ID in "mysqladmin processlist;"

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,965
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    It's really not a good idea to attempt to kill database processes as a method for reducing usage. Instead, you may want to consider suspending the account and restarting MySQL if you want to ensure it's disabled. The following thread is useful for obtaining information on tuning your MySQL:

    mysqlmymonlite.sh server stats gathering tool for cPanel Server

    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