… showing how Lazy Drop Table and the new DROP Table in MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in… the old implementation of drop table, but the “Lazy Drop Table” implementation wins here. The dips are there in the case of “Lazy Drop Table” but the dips… the DROP TABLE, and I think this is something that could be implemented in “Lazy Drop Table” to further improve the overall performance during background DROP TABLE…

… setup a config variable for the “lazy drop table” feature to work. The variable to set is “innodb_lazy_drop_table“: http://www.percona.com/docs/wiki/percona-server:features:misc_system_variables#innodb_lazy_drop_table Its a dynamic variable…

… was the dropped table. I don’t think this is realistic and the results don’t surprise me. The overhead for lazy drop table is a function of the length of the LRU. The overhead for new drop table is a function of… the dropped table. I doubt this reflects the typical drop table and it minimizes the overhead from scanning the LRU. Your test makes lazy drop table look…

… the other three continue as normal. This reduces the peak drop from 100% to 25%. Now consider ten pools, the maximum…’s version of drop table relies on taking the buffer pool mutex and a mutex on the flush list, “Lazy Drop Table” implementation relies on… these things are an improvement over the previous implementation of DROP TABLE, but do they make enough difference. I feel that the…

There is a bug in DROP TABLE on MySQL. Because of it my production servers hanged. https://bugs.launchpad.net/percona-server/+bug/1026926 Now I’m using innodb_lazy_drop_table.