Geek asks and answers

MySQL dumping foreign key too slowly?

Dropping a foreign key in a table with a record of 215k + (with an alter table) seems to take a lot of time (17+ minutes). Is there any way to speed up the process? SQL: ALTER TABLE sales_flat_order_gridDROP FOREIGN KEY FK_SALES_FLAT_ORDER_GRID_STORE;

This is a magenta update that requires age.

+5
source share
1 answer

If you are not using the InnoDB plugin (and by default in MySQL 5.0 and 5.1 you are not), deleting the index requires restoring the whole table.

MySQL, - ( ), , - .

+3

More articles:


All Articles