Skip to main content
Skyhigh Security

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

Version

Content Security Reporter 2.x

Description

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:

[mysqd_safe]

open-files-limit=16000

For more information, see the MySQL documentation:

  • Was this article helpful?