# Dealing with MySQL resource shortage

DevFeed: [Dealing with MySQL resource shortage](<https://devfeed.tech/articles/dealing-with-mysql-resource-shortage-41577.md>)

Original publisher: [Read original article](<https://blog.benjojo.co.uk/post/2014-04-17-mysql-resource-shortage.md>)

Author: ben@benjojo.co.uk

Published: 2014-04-17T19:02:11Z

Content type: tutorial

Language: en

Sources: [Benjojo](<https://devfeed.tech/sources/benjojo-blog.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [errors](<https://devfeed.tech/tags/errors.md>), [file](<https://devfeed.tech/tags/file.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [resource](<https://devfeed.tech/tags/resource.md>), [server](<https://devfeed.tech/tags/server.md>), [shortage](<https://devfeed.tech/tags/shortage.md>)

## AI overview

A troubleshooting guide for MySQL resource errors caused by a low open-file limit, especially when using many databases or InnoDB tables. It recommends updating system and MySQL configuration, rebooting the server, and checking available disk space if the issue persists.

## Source excerpt

Dealing with MySQL resource shortage You may in life while working with mysql get the following errors: ERROR 1016 (HY000) at line 1: Can't open file: './blah/table.frm' (errno: 24) or ``` SQL Error (23): Out of resources when o