One day, I received a user consultation on the road. In order to clear the space, I wanted to delete the data of a large table of more than 200 G, and it was confirmed that this table no longer has business access, so I executed a command ‘delete from bigtable’, but it took a long time. I didn’t delete it. After consulting, I learned that drop table deletes the table quickly and can completely free up space, so I executed the ‘drop table bigtable’ command in another session, but this command does not…

#Daily #blog #Step #step #understand #MySQL #metadata #lock #MDL