When trying to execute optimize table history_uint:
MariaDB [zabbix]> optimize table history_uint;
+ --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
| Table | Op | Msg_type | Msg_text |
+ --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
| zabbix.history_uint | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| zabbix.history_uint | optimize | error | Temporary file write failure |
| zabbix.history_uint | optimize | status | Operation failed |
+ --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
at the same time, if you run optimize table history, then:
MariaDB [zabbix]> optimize table history;
+ ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
| Table | Op | Msg_type | Msg_text |
+ ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
| zabbix.history | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| zabbix.history | optimize | status | OK |
+ ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
MariaDB [zabbix]> optimize table history_uint;
+ --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
| Table | Op | Msg_type | Msg_text |
+ --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
| zabbix.history_uint | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| zabbix.history_uint | optimize | error | Temporary file write failure |
| zabbix.history_uint | optimize | status | Operation failed |
+ --------------------- + ---------- + ---------- + ----- -------------------------------------------------- ------------ +
at the same time, if you run optimize table history, then:
MariaDB [zabbix]> optimize table history;
+ ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
| Table | Op | Msg_type | Msg_text |
+ ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +
| zabbix.history | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| zabbix.history | optimize | status | OK |
+ ---------------- + ---------- + ---------- + ---------- -------------------------------------------------- ------- +