目前有一张日志表,我给该表删除了1亿多条数据,想到是否需要优化下该表。
mysql> OPTIMIZE TABLE article_rank;
+----------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+----------+----------+-------------------------------------------------------------------+
| yunqidb.article_rank | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| yunqidb.article_rank | optimize | error | Duplicate entry '675718-20181229' for key 'u_aid_day' |
| yunqidb.article_rank | optimize | status | Operation failed |
+----------------------+----------+----------+-------------------------------------------------------------------+
3 rows in set, 1 warning (1 min 23.29 sec)