drop table price;Query OK, 0 rows affected (3 min 32.06 sec)
The price table has 20 million pieces of data. It took more than three minutes to delete it. Is it normal?
For this quantity level, it is recommended to use the error storage process. Through do - Will loop, delete 1000 items each time, write some logic code, and output the progress of task operation.
You can use hard links to delete large tables