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!

MySQL eating memory... server overload

Discussion in 'General Discussion' started by dazmanultra, Aug 23, 2005.

  1. dazmanultra

    dazmanultra Member

    Joined:
    Nov 9, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    151
    cPanel Access Level:
    DataCenter Provider
    Basically MySQL seems to decide to eat loads of memory, randomly. This causes the server to use swap, and then it's thrashing all over the place and services start failing.

    Any ideas?
    (see the attached image)
     

    Attached Files:

  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,470
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    The image you attached is pretty much meaningless. You need to establish which MySQL database and what lookups are causing the problem with MySQL on your server. There is good information on the MySQL site to do this type of thing and information about how to do MySQL tuning if you haven't done any of that. A starting place could be WHM > Show MySQL Processes
     
    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