MySQL open_files_limit question

1 post / 0 new
#1 Sat, 05/20/2017 - 21:42
jaldeguer

MySQL open_files_limit question

Hi,

I run into a problem where all of my databases were not showing up in Webmin MySQL database module, even though I can see all of them in /var/lib/mysql. If anyone browsed any of the 15 Wordpress websites I was hosting each one came up with the page to install a new Wordpress site. I re-ran the Virtualmin wizard and picked the option (huge system for heavily used mysql) to try to fix the problem thinking it may be some inadequate resource issue. But the solution was I had to add the line below in my /etc/my.cnf file. My question is, is 5000 enough and what potential problems I'm I creating by adding this setting?

[mysqld]

open_files_limit = 5000