drop
A kind of DDL operation that removes a schema object, through a statement such as DROP TABLE or DROP INDEX. From an InnoDB perspective, the performance considerations of such operations involve the time that the data dictionary is locked to ensure that interrelated objects are all updated, the time that is and the time to update memory structures such as the buffer pool. For a table, the drop operation has somewhat different characteristics than a truncate operation (TRUNCATE TABLE statement).
See also buffer pool.
See also data dictionary.
See also DDL.
See also table.
See also truncate.