MySQL open files limit

Hits: 5507  

Upgrade Migration – Kaltura CE 4.0 to 5.0

I was migrating Kaltura from CE 4.0 to 5.0 but following MySQL error made me unhappy 🙁

One or more prerequisites required to install Kaltura failed:
Please set ‘open_files_limit >= 20000’ in my.cnf and restart MySQL (current value is 1024)

# ulimit -a | grep “open files”

# ulimit -n (get and set user limit on resources)

mysql> show variables like ‘open_file%’;

The open file limit is an important variable for performance when MySQL server has to open several files at once. If open_files_limit is set to a lower value then MySQL query might fail causing other problems or might take too long to execute.

Then I have changed /etc/my.cnf

I had put the open_files_limit line in the [mysqld_safe] section, but it seems that section is no longer used. So, I have Moved all config options to [mysqld]

Even Lion Takes few Step Back Before It Jumps forward… So whenever Life Pulls u Back, Don’t Worry, It’s Going To Lead you forward To A Great Victory!

Published by

Sandeep Verma

I’m an Entrepreneur. I’m proud to work as Blogger, LAMP Programmer, Linux Admin, Web Consultant, Cloud Manager, Apps Developer, Searcher. Concentrate > Observe > Imagine > Launch

6 thoughts on “MySQL open files limit”

  1. Nice post. I learn something totally new and challenging on blogs I stumbleupon everyday.
    It’s always useful to read articles from other authors and
    practice a little something from other websites.

  2. I am curious to find out what blog system you’re
    working with? I’m experiencing some minor security issues
    with my latest site and I’d like to find something more risk-free.
    Do you have any solutions?

  3. I truly love your website.. Very nice colors & theme.
    Did you build this site yourself? Please reply back as I’m planning to create my very
    own site and would like to know where you got this from or what the theme is named.


  4. Oh my goodness! Incredible article dude! Thank you, However I am having
    difficulties with your RSS. I don’t know the reason why I can’t subscribe
    to it. Is there anybody else having the same RSS problems?
    Anyone that knows the answer will you kindly respond?

  5. Hi! I know this is kinda off topic but I was wondering
    which blog platform are you using for this website?
    I’m getting tired of WordPress because I’ve had issues with hackers and I’m looking at alternatives for another platform.

    I would be fantastic if you could point me in the direction of a good platform.

Leave a Reply

Your email address will not be published.