Pak Jiddat - Innovative Software Services

Read: In the name of thy Lord Who createth, Createth man from a clot. Read: And thy Lord is the Most Bounteous, Who teacheth by the pen, Teacheth man that which he knew not. Nay, but verily man is rebellious That he thinketh himself independent!. Lo! unto thy Lord is the return. (Sura Alalaq 96:8)

MySQL server out of resources

Created On: 15 Feb, 2017: 15:18:58 - Tags : database management

Url: https://support.plesk.com/hc/en-us/articles/213945545-Cannot-login-to-Plesk-SQLSTATE-HY000-General-error-23-Out-of-resources

If you get following error on your mysql/mariadb server: General error: 23 Out of resources, then a possible solution is to increase the open_file_limit mysql variable. On Centos 7, this can be done by first creating the folder: /etc/systemd/system/mariadb.service.d/, then adding the following lines to limits.conf in the new folder:


[Service]
LimitNOFILE=20000
After that restart the mysql/mariadb service with the command:

systemctl daemon-reload
systemctl restart mariadb.service

Related Articles

  1. Upgrading Postgresql from version 9.4 to 9.6
  2. Upgrading MySQL server from version 5.6 to 8.0
  3. Ignoring errors during MySQL import
  4. MariaDB/MySQL user password not being set
  5. Sorting a MySQL string column as a number
  6. MySQL Tuner
  7. Create backup of Mongo Db database
  8. Deleting a Mongo Db database
  9. How to login to MySQL server as root user on Plesk
  10. Restoring a database backup in Plesk
  11. List all databases for Postgresql
  12. Solution for mysql header mismatch error
  13. Backing up and Restoring MongoDB data
  14. Removing Replication in MongoDb
  15. Exporting Mysql database data in CSV format using Mysql Work Bench