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

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

  1. Kyle Moore

    Kyle Moore Registered

    Joined:
    Oct 11, 2011
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    1
    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,279
    Likes Received:
    36
    Trophy Points:
    48
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    StevenM. likes this.
  3. Kyle Moore

    Kyle Moore Registered

    Joined:
    Oct 11, 2011
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    1
    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,279
    Likes Received:
    36
    Trophy Points:
    48
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    Kyle,

    Hopefully that works for you. Do let us know.

    Mike
     
  5. albatroz

    albatroz Well-Known Member

    Joined:
    Mar 6, 2003
    Messages:
    258
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
Loading...

Share This Page