首页 > 数据库技术 > 详细

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

时间:2019-06-26 11:29:49      阅读:189      评论:0      收藏:0      [点我收藏+]

地区:铁力

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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!