4

I'm researching database configuration for MySQL/MariaDB. I've been reading the configuration chapter in "High Performance MySQL". In there, it suggests that innodb_lazy_drop_table can be used to avoid server stalls when dropping tables if innodb_file_per_table is set, to stop an immediate scan of the buffer pool to invalidate pages that refer to the dropped table.

However, I also found that innodb_lazy_drop_table has now been removed from XtraDB.

Does that mean the original issue is fixed, and I no longer have to worry about performance issues when dropping InnoDB/XtraDB tables? Or perhaps the lazy invalidation of pages has been enabled by default and the configuration option is all that's been removed?

RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536
Alex
  • 151
  • 5

1 Answers1

2

It seems to be fixed (see percona manual):

Feature has been removed because the upstream DROP TABLE implementation has been improved.

Jens D.
  • 1,229
  • 1
  • 9
  • 16