mysql
-- show index show indexes from table_name -- remove FK ALTER TABLE `table_name` DROP FOREIGN KEY `FK_name`; ALTER TABLE `table_name` DROP INDEX FI_name;
source en http://dev.mysql.com/doc/refman/5.1/en/internal-locking.html ja http://dev.mysql.com/doc/refman/5.1/ja/internal-locking.html memo MyISAM, memory, merge tables は table-level、InnoDB は row-level table-lock deadlock free (飛ばし…