mysql default open_files_limit too low

My issue votes
0
votes
0/20 total votes used
Project:Kaltura Community Edition (CE) - Self Hosted Online Video Platform
Version:Dragonfly
Component:Documentation
Category:task
Priority:minor
Assigned:Unassigned
Status:active
Total votes:1
Description

After logging into my fresh CE 4.0 installation, I only got the famous "an error has occurred" screen...

In this case, I traced it back to mysql, which was reporting "out of resources when opening file ... (Errcode: 24)".

Turns out CE comes with so many database tables that the default limit for opened files in my fresh installation of MySQL / Debian is too low.
Solution was to add "open_files_limit = 8192" to my.cnf.

This should definitely be pointed out in the installation guide!

Comments

#1

The default limit is 1024.
The number of files in /var/lib/mysql right after CE installation is around 1650.