Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "the disk space release process of MySQL5.7 table after deleting data". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

First of all, delete data.

Mysql > optimize table report

+-+

| | Table | Op | Msg_type | Msg_text | |

+-+

| | du.report | optimize | note | Table does not support optimize, doing recreate + analyze instead | |

| | du.report | optimize | error | Error writing file'. / du/#sql-3a1_2da46.frm' (Errcode: 28-No space left on device) |

| | du.report | optimize | status | Operation failed | |

+-+

3 rows in set, 1 warning (0.04 sec)

Optimize is not supported.

And there's not enough space.

Mysql > truncate table report

ERROR 1030 (HY000): Got error 168from storage engine

Free up a little space to truncate the table.

Mysql > truncate table report

Query OK, 0 rows affected (2.82 sec)

Free up the disk space occupied by the table:

Mysql > alter table report ENGINE='InnoDB'

Query OK, 0 rows affected (11 min 56.05 sec)

Records: 0 Duplicates: 0 Warnings: 0

Complete space release.

This is the end of the content of "disk space release process after deleting data from MySQL5.7 table". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.