How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?
How to troubleshoot slow performance of MySQL on a Plesk server?
How to copy a MySQL database in Plesk
MariaDB is not able to start: Got error '144 "Table is crashed and last repair failed"' for './mysql/global_priv'
Unable to restore the psa database from dump: Data truncated for column 'event_type' at row X
Database server list can't be accessed: 500 GraphQL Internal Server Error
Unable to create a backup of PostgreSQL database: pg_dump: aborting because of server version mismatch
Unable to clone or backup MSSQL database in Plesk: Property TextHeader is not available for StoredProcedure <...>. The text is encrypted
MySQL/Mariadb fails to start: Upgrade after a crash is not supported
How to manage a database hosted in Plesk using a local database client?

See more

MySQL error on the server with Plesk: Could not increase number of max_open_files to more than 16384

Gabriel Aznarez

Updated November 17, 2023 04:08

DoNotDelete:docref Plesk for Linux kb: technical ABT: Group B

Applicable to:

Plesk for Linux

Symptoms

The following error can be seen when checking MariaDB status:

# systemctl status mariadb
MySQL error: Could not increase number of max_open_files to more than 16384 (request: 32335).
MySQL/MariaDB performance is slow.

Cause

Hard limit of the process exceeded the number set for open files limit (16384) in /etc/systemd/system/mysqld.service:

CONFIG_TEXT: #Number of files limit
LimitNOFILE=16384

Resolution

Connect to the server via SSH.
Edit file /etc/systemd/system/mysqld.service :
Change the line LimitNOFILE as follows:

CONFIG_TEXT: LimitNOFILE=32335
Reload daemons:

# systemctl daemon-reload
Restart mariadb service:

# systemctl restart mariadb

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request