「MySQL」- Temporary file write failure

问题

当执行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