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.

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:
    1
    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:
    6
    Location:
    Uruguay
    cPanel Access Level:
    Root Administrator
  3. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    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:
    14,447
    Likes Received:
    195
    Trophy Points:
    63
    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.
     
  5. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    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:
    4
    Trophy Points:
    18
    Location:
    Athens Greece
Loading...

Share This Page