mysql - 无法在 Ubuntu 14.04 上启动 mysql 服务器

Question

当我访问我的站点时，我发现没有与 mysql 服务器的连接。我登录到我的 vps。我试图重新启动 mysql 但后来我看到了这个

root@vps138972:~# sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld
[ OK ] * Checking for tables which need an upgrade, are corrupt or were not closed cleanly.

root@vps138972:~# ERROR 23 (HY000) at line 1: Out of resources when opening file
'./admin_naturello/oc_profile_description.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_return.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_return_action.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_return_history.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_return_reason.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_return_status.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_review.MYD' (Errcode: 24) ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_revolution_slider.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_setting.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_stock_status.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_store.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_tax_class.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_tax_rate.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_tax_rate_to_customer_group.MYD' (Errcode: 24) ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_tax_rule.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_url_alias.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_user.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_user_group.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_voucher.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_voucher_history.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_voucher_theme.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_voucher_theme_description.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_weight_class.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_weight_class_description.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_zone.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_naturell
o/oc_zone_to_geo_zone.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_presta/c
atalogsearch_fulltext.MYD' (Errcode: 24)

ERROR 23 (HY000) at line 1: Out of resources when opening file './admin_presta/o
auth_nonce.MYD' (Errcode: 24)

Answer 1

MYSQL:打开文件时资源不足...(错误代码:24)

mysql error: Out of resources when opening file... (Errcode: 24) 表示超过了msyql允许打开的文件数。此限制由变量 open_files_limit 控制。您可以在 phpMyAdmin(或 MySQL 命令行实用程序)中使用以下语句阅读此内容:

SHOW VARIABLES LIKE 'open%'

要将此变量设置为更大的数字，请编辑/etc/my.cnf 文件并添加以下行:

[mysqld]
open_files_limit = 5000

然后一定要重启mysql:sudo/etc/init.d/mysql restart

请记住在编辑文件时使用服务器管理帐户和 sudo。编辑器的选择取决于您。现在，显示变量应该显示您选择的数字。

请注意，上面显示的 5000 是一个示例。一个好的经验法则是将当前文件数加上 1000。如果这没有帮助，请添加更多。这个数字会影响 MySQL 使用的内存量，因此将它设置为一个非常高的数字并不是一个好主意。

来源:secure hens-teeth , secure vexxhost