「MySQL」- Temporary file write failure

  CREATED BY JENKINSBOT

问题描述

当执行OPTIMIZE TABLE时,产生如下错误:

+--------------------+----------+--------+-------------------------------------------------------------------+
| zabbix.trends_uint | optimize | note   | Table does not support optimize, doing recreate + analyze instead |
| zabbix.trends_uint | optimize | error  | Temporary file write failure.                                     |
| zabbix.trends_uint | optimize | status | Operation failed                                                  |
+--------------------+----------+--------+-------------------------------------------------------------------+
3 rows in set, 1 warning (9 min 36.12 sec)

问题原因

在执行watch -n 1 df -h -P时,我们发现磁盘空间用量在不断增加,直至全部使用。

解决办法

暂未解决

参考文献

Temporary file write failure on MySQL