铁力项目mysql异常处理过程记录

地区：铁力

故障：
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

铁力项目mysql异常处理过程记录

原文：https://www.cnblogs.com/littlehb/p/11088547.html