How to Set the Maximum Number of Open Files for an external MySQL database

Version

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.

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:

[mysqd_safe]

open-files-limit=16000

For more information, see the MySQL documentation: