Ad Widget

Collapse

Ошибка при попытке сделать optimize table history_uint

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GeorgeKup
    Member
    • Nov 2019
    • 98

    #1

    Ошибка при попытке сделать optimize table history_uint

    При попытке выполнить 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 |
    +---------------------+----------+----------+-------------------------------------------------------------------+
    в то же время, если выполнить optimize table history, то :

    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 |
    +----------------+----------+----------+-------------------------------------------------------------------+

Working...