~mysql/mysql-server/mysql-5.1

Viewing all changes in revision 3603.

  • Committer: Vasil Dimov
  • Date: 2011-09-07 14:58:10 UTC
  • Revision ID: vasil.dimov@oracle.com-20110907145810-v98kldmho23vhhic
Use cursors for seeking records in SYS_FOREIGN and SYS_INDEXES from
DROP_TABLE_PROC().

With this change I observe a speedup from 6.2s to 0.1s when executing
DROP_TABLE_PROC() during DROP TABLE with 512 foreign keys, like what
is being done in innodb_bug56143.test

This fixes "Bug#11765460 DROP TABLE USES INEFFICIENT METHODS TO REMOVE
FKS/INDEXES FROM INNODB SYS TABLES"

Reviewed by:    Marko

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: