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.

mySQL running out of memory.

Discussion in 'General Discussion' started by Nishant80, Jun 7, 2012.

  1. Nishant80

    Nishant80 Well-Known Member

    Joined:
    May 7, 2012
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,
    It is a new server that we deployed and migrated about 1000 websites to it. The problem is, very frequently we get error statning mySQL is running out of memory. Server has 24GB RAM :O and load always averages around 2.0 (which is fair).

    Can you tell me how exactly can I check how much memory has been allocated and how can I elevate that limit?
     
  2. MilesWeb

    MilesWeb Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2012
    Messages:
    174
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    AFAIK, there is nothing you can limit for mysql unless and until you are using any custom toll like Cloudlinux. You need to tweak mysql on server and monitor it's usage. You will be then action accordingly.
     
  3. Nishant80

    Nishant80 Well-Known Member

    Joined:
    May 7, 2012
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hi @milesgeek,
    That was pretty broad actually. My question was, how do I check how much RAM has been allocated to mysql? Because I am pretty sure the allocation is not enough for it to run smoothly. And how can I allocate more?
     
  4. hostproof

    hostproof Member

    Joined:
    Mar 9, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Europe
Loading...

Share This Page