MySQL open files limit

Hits: 5340  

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