地区:铁力
故障:
2019-06-26 10:19:34 139921514837760 [ERROR] mysqld: Error writing file ‘mysql-bin‘ (errno: 11 "Resource temporarily unavailable")
2019-06-26 10:19:34 139921514338048 [ERROR] mysqld: Error writing file ‘mysql-bin‘ (errno: 11 "Resource temporarily unavailable")
2019-06-26 10:19:35 139921514338048 [ERROR] mysqld: Error writing file ‘mysql-bin‘ (errno: 11 "Resource temporarily unavailable")
2019-06-26 10:21:26 139921514837760 [ERROR] mysqld: Error writing file ‘mysql-bin‘ (errno: 11 "Resource temporarily unavailable")
2019-06-26 10:21:29 139921514338048 [ERROR] mysqld: Error writing file ‘mysql-bin‘ (errno: 11 "Resource temporarily unavailable")
2019-06-26 10:21:47 139918920025856 [ERROR] mysqld: Error writing file ‘mysql-bin‘ (errno: 11 "Resource temporarily unavailable")
==============================================================
对比好用的机器:
10.10.14.159
MariaDB [(none)]> show variables like ‘%open\_%‘;
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| innodb_open_files | 16384 |
| open_files_limit | 16384 |
| table_open_cache | 512 |
+-------------------+-------+
3 rows in set (0.01 sec)
==============================================================
铁力故障服务器
MariaDB [(none)]> show variables like ‘%open\_%‘;
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| innodb_open_files | 1024 |
| open_files_limit | 10245 |
| table_open_cache | 1024 |
+-------------------+-------+
3 rows in set (0.00 sec)
问题已经很明确,是文件打开数不足。
==============================================================
替换10.10.14.159的/etc/my.cnf,问题解决。
检查一下:
mysql -uroot -p*******
MariaDB [(none)]> show variables like ‘%open\_%‘;
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| innodb_open_files | 16384 |
| open_files_limit | 16384 |
| table_open_cache | 512 |
+-------------------+-------+
3 rows in set (0.00 sec)
附件:好用my.cnf https://files.cnblogs.com/files/littlehb/my.zip
原文:https://www.cnblogs.com/littlehb/p/11088547.html