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 Locking up - To Many Open Files?

Discussion in 'Database Discussion' started by Kyle Moore, Apr 30, 2012.

  1. Kyle Moore

    Kyle Moore Registered

    Joined:
    Oct 11, 2011
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    53
    Location:
    Worcester, Worcestershire, United Kingdom
    cPanel Access Level:
    Root Administrator
    Hi guys and girls,

    I'm getting really annoyed at this issue now and I've never experienced a problem like this before so I'm a little confused. I've been in touch with support and they narrowed the issue down to "To many open files" error code 24.

    I've pasted some logs below of what I can dig out of MySQL Logs. I've increased max files open on the server to 900,000 and the softlimit of for open files on MySQL is 24000 (was 4000) and hardlimit is 32000 (was 4000).

    Any ideas? :(

    Thank you!

     
  2. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,338
    Likes Received:
    56
    Trophy Points:
    178
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    StevenM. likes this.
  3. Kyle Moore

    Kyle Moore Registered

    Joined:
    Oct 11, 2011
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    53
    Location:
    Worcester, Worcestershire, United Kingdom
    cPanel Access Level:
    Root Administrator
    Hello Mike.

    I think you may have hit the nail on the head. Link bookmarked!

    I've only been looking OS side not MySQL. I'll see how I get on that you!
     
    StevenM. likes this.
  4. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,338
    Likes Received:
    56
    Trophy Points:
    178
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    Kyle,

    Hopefully that works for you. Do let us know.

    Mike
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. albatroz

    albatroz Well-Known Member

    Joined:
    Mar 6, 2003
    Messages:
    315
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Virtual Orbis / Peru
    cPanel Access Level:
    Root Administrator
    I got the same error messages so I changed the open_files_limit from 1284 to 99000.
    I will wait and see what happens.
     
    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