…) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has been removed because the upstream DROP TABLE implementation… fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227 and…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has been removed because the upstream DROP TABLE implementation… fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227 and…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… for when you are using innodb_file_per_table. Implementation Before going into showing how Lazy Drop Table and the new DROP Table in MySQL >= 5.5… version of Percona Server used for benchmarking Lazy Drop Table is Percona Server 5.5.24 (innodb_lazy_drop_table=1) Now so much for the details…
Post: Drop table performance
April 20, 2011 By 22 Comments
… DROP TABLE performance in InnoDB. (You can refer to Peter’s post http://www.mysqlperformanceblog.com/2011/02/03/performance-problem-with-innodb-and-drop-table… dropped it. I measured the time to drop 1000 times in MySQL 5.1.56, in Percona Server 5.1.56 with “innodb_lazy_drop_table… 2.6x better than MySQL 5.6.2. (Disclaimer: The “innodb_lazy_drop_table” feature in Percona Server and this benchmark are sponsored by…
Comment: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… “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 as well, so you can turn this feature on without having to restart mysqld: SET GLOBAL innodb_lazy_drop_table…
Post: Percona Server and XtraBackup weekly news, February 26th
February 27, 2011 By 5 Comments
… fix for InnoDB‘s slow DROP TABLE performance. A new option, innodb_lazy_drop_table, controls this behavior. Vadim asked Yasufumi to look into porting the innodb_sync…. In XtraBackup news, Alexey completed moving streaming functionality from innobackupex. InnoDB files are now streamed by the xtrabackup binary, and tar4ibd…
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
… #757749 – Using ALTER TABLE to convert an InnoDB table to a MEMORY table could fail due to a bug in innodb_expand_fast_index_creation… some cases when innodb_lazy_drop_table was enabled with very large buffer pools. (Yasufumi Kinoshita) Bug #733317 – SYS_STATS internal table of XtraDB has…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
… innodb_autoinc_lock_mode=1. Bug fixed #1035225 (Alexey Kopytov). Removed error log warnings that occured after enabling innodb_use_sys_stats_table and before ANALYZE TABLE is run for each table. Bug fixed #890623 (Alexey Kopytov… for this bug exists and it’s setting up the innodb_lazy_drop_table to 1. Release notes for Percona Server 5.5.27…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… error instead. Bug Fixed: #704216 (Laurynas Biveinis). Querying INNODB_SYS_TABLES after an ALTER TABLE statement leaded to a server crash. Bug Fixed…: #803865 (Laurynas Biveinis). Using the innodb_lazy_drop_table option led to an assertion error when truncating a table in some scenarios. Bug Fixed:#798371…
Comment: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
September 1, 2012 By 33 Comments
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.
