See also:http://www.mysqlperformanceblog.com/2011/04/20/drop-table-performance/ We fixed this problem in Percona Server, release 5.5.10-20.1 with the innodb_lazy_drop_table option.
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
… avoided when upgrading to Percona Server by converting the affected tables or columns to the collations introduced: utf8_general_ci to… may evict and close another if the table cache is full. If the closed table was on the FEDERATED engine and a…:#745241 (Alexey Kopytov). Using the innodb_lazy_drop_table option led to an assertion error when truncating a table in some scenarios. Bug Fixed:#798371…
Post: Percona Server and XtraBackup weekly news, March 5th
March 6, 2011 By Leave a Comment
… repository for Ubuntu users. If you’re waiting for the innodb_lazy_drop_table feature in Percona Server, unfortunately it doesn’t look like… data. This would prevent queries from needing to enter the InnoDB kernel during the planning phase, which can be a severe…
Comment: Announcing Percona Server 5.5.27-28.0
August 27, 2012 By 5 Comments
Okay, we have a plan to do a -28.1 release with a few bug fixes and we’ve seen a couple of people with a problem that wasn’t solved by setting innodb_lazy_drop_table to 1, so we’re also investigating that.
Comment: Announcing Percona Server 5.5.27-28.0
August 27, 2012 By 5 Comments
It just crashed with the same error while running latest Percona-Server-5.5.27-rel28.0, even with innodb_lazy_drop_table set to 1, so it is not a working workaround, see the crash log: https://gist.github.com/3486469
Comment: Slow DROP TABLE
May 24, 2012 By 21 Comments
If you’re using percona xtradb binaries you can use this option to reduce the pain. http://www.percona.com/doc/percona-server/5.1/performance/innodb_lazy_drop_table.html ‘njoy, Mark
Comment: Drop table performance
April 20, 2011 By 22 Comments
We fixed this problem in Percona Server, release 5.5.10-20.1 with the innodb_lazy_drop_table option.
Comment: Drop table performance
April 21, 2011 By 22 Comments
… of this drop table issues, I was seeing lockups dropping very small tables with innodb buffer pool set to 24G. It appears that the lazy drop table flag is invald when innodb_file_per_table=0…
Comment: Drop table performance
April 20, 2011 By 22 Comments
… of this drop table issues, I was seeing lockups dropping very small tables with innodb buffer pool set to 24G. It appears that the lazy drop table flag is invald when innodb_file_per_table=0…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
… Multi-Threaded Purge, Separate Flush Thread, Pruning the InnoDB Table Cache This article was for scaling inserts …(inserts per second) with less threads. So after dropping number of threads on both clusters by 50% …Use more eager writing in parellel instead of lazy writng to disk and set lower dirty …
