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