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!

How to separate system resource for each account used MySQL

Discussion in 'Workarounds and Optimization' started by lowhigh, Jul 4, 2011.

  1. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    51
    Hi everybody!

    I have many cusomters with many their own websites. Each of them used different CMS with different coding style.
    So, some websites when loading using very much CPU resource in MySQL (some time 300%CPU/4 CPUs), i often monitor with Daily process log but i don't know to restrict user with MySQL resource although i have made MySQL tunning.

    Is there any way to statisfy my requirement? Thanks all!
     
  2. fi77i

    fi77i Well-Known Member

    Joined:
    Aug 20, 2008
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Uruguay
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    51
    I have raed these posts but nothing improved. Anybody has idea???
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,436
    Likes Received:
    416
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    I'm not sure this is the best way to be monitoring processes, these details could be spikes lasting a second or two.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    51
    Hi Infopro!

    You can explain me that how the item "Daily process log" works!
    I really don't know how to monitor this mysql process efficiently! I have never hear any tools for this purpose! Have you got any idea?
     
  6. k-planethost

    k-planethost Well-Known Member

    Joined:
    Sep 22, 2009
    Messages:
    199
    Likes Received:
    8
    Trophy Points:
    68
    Location:
    Athens Greece
    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