HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is the innodb_lazy_drop_table problem solved?

Submitted by: @import:stackexchange-dba··
0
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 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.

Context

StackExchange Database Administrators Q#60840, answer score: 2

Revisions (0)

No revisions yet.