Skip to main content

Check out Interactive Visual Stories to gain hands-on experience with the SSE product features. Click here.

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?