MySQL大量的delete后空间如何回收
mysql> optimizetable m; +-------+----------+----------+-------------------------------------------------------------------+| Table | Op | Msg_type | Msg_text |
+-------+----------+----------+-------------------------------------------------------------------+
| stu.m | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| stu.m | optimize | status | OK |
+-------+----------+----------+-------------------------------------------------------------------+
You can make OPTIMIZE TABLE work on other storage engines by starting mysqld with the --skip-new or --safe-modeoption. In this case, OPTIMIZE TABLE is just mapped to>
页:
[1]