Re: [Maria-discuss] .ibd files remaining after DROP TABLE
Hi, It only seems to happen when replicating DROP TABLE IF NOT EXISTS from a master, not when running it directly on that server. I can replicate this problem every time. Thanks, Andrew On 17 September 2014 15:49, Jan Lindström <jan.lindstrom@skysql.com> wrote:
Hi, Andrew! On Sep 17, Andrew Braithwaite wrote:
I tried to repeat it (just like you said, create a master-slave setup, DROP TABLE IF EXISTS on master, see what happens on the slave). Everything worked as documented - both .frm and .ibd files were deleted. Could you try to create a complete repeatable test case? Also - as it looks like a bug - you could consider reporting it at mariadb.org/jira
Regards, Sergei
Hello. I've read in this page https://mariadb.com/kb/en/mariadb/documentation/sql-commands/table-commands/... that OPTIMIZE TABLE defragments InnoDB tables in 10.1. Good news! Just some questions: What locks are acquired? Is the table copied? Is the operation atomic? Regards Federico
participants (3)
-
Andrew Braithwaite -
Federico Razzoli -
Sergei Golubchik