How to Set the Maximum Number of Open Files for an external MySQL database
Content Security Reporter 2.x
Content Security Reporter shows a database status of System set to offline when you click Partition Schema.
When you use the MyISAM storage engine in MySQL, the partitioning a database requires several open files that exceed the default limit of 2048.
How to Configure
To increase the maximum number of open files, you must set the open-files-limit system variable to a value greater than or equal to 16,000.
Add the following lines to the MySQL option file:
For more information, see the MySQL documentation: