SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2012
    Location
    Cape Town, South Africa
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Open File Limit

    Hi Guys,

    I received the following issue today in mysql log file.
    This is a shared Web Hosting Server.

    I performed the following as per link:
    http://info.solomonson.com/content/h...errno-24-mysql

    Errors seem to have gone away. It seems the default was on 4096 in mysql. I set it to 300000.

    Is this smart or any other recommendations on this for shared hosting.

  2. #2
    Community Advisor silver trophy

    Join Date
    Nov 2006
    Location
    UK
    Posts
    2,551
    Mentioned
    40 Post(s)
    Tagged
    1 Thread(s)
    You can't change your mysql config file on shared hosting.

  3. #3
    Twitter: @TimIgoe silver trophy TimIgoe's Avatar
    Join Date
    Feb 2005
    Location
    Blackpool, UK
    Posts
    1,056
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)
    4096 files should be ok for most uses, unless theres a lot of things going on at the same time on the server - if its a shared host, it should be up to your provider to manage things like that for you. Contact them and tell them you are running into an open files limit and can they adjust the mysql settings?

  4. #4
    SitePoint Enthusiast
    Join Date
    Nov 2012
    Location
    Cape Town, South Africa
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by TimIgoe View Post
    4096 files should be ok for most uses, unless theres a lot of things going on at the same time on the server - if its a shared host, it should be up to your provider to manage things like that for you. Contact them and tell them you are running into an open files limit and can they adjust the mysql settings?
    Thanks I went for 4096 and will see how it goes.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •