patternsqlMinor
Is the innodb_lazy_drop_table problem solved?
Viewed 0 times
solvedproblemtheinnodb_lazy_drop_table
Problem
I'm researching database configuration for MySQL/MariaDB. I've been reading the configuration chapter in "High Performance MySQL". In there, it suggests that
However, I also found that
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?
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?
Solution
It seems to be fixed (see percona manual):
Feature has been removed because the upstream DROP TABLE implementation has been improved.
Feature has been removed because the upstream DROP TABLE implementation has been improved.
Context
StackExchange Database Administrators Q#60840, answer score: 2
Revisions (0)
No revisions yet.