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,
Not at least normally both should be deleted, but maybe not immediately. Can you provide a example ?
R: Jan
On Wed, Sep 17, 2014 at 4:36 PM, Andrew Braithwaite < andrew.braithwaite@graze.com> wrote:
Hi,
After dropping tables on my MariaDB 10.0.13 database server, the .frm files are removed but the .ibd files remain behind.
Has anyone seen this before?
Thanks.... Andrew
mysqld Ver 10.0.13-MariaDB-1~trusty for debian-linux-gnu on x86_64 ( mariadb.org binary distribution)
DISTRIB_ID=Ubuntu DISTRIB_RELEASE=14.04 DISTRIB_CODENAME=trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.1 LTS" NAME="Ubuntu" VERSION="14.04.1 LTS, Trusty Tahr" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 14.04.1 LTS" VERSION_ID="14.04" HOME_URL="http://www.ubuntu.com/" SUPPORT_URL="http://help.ubuntu.com/" BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
--
--
Jan Lindström, Principal Engineer SkySQL - The MariaDB Company
skype: jan_p_lindstrom
www.skysql.com <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=AFrqEzcZuouapPzP5SJcV6B_sk4rcBAMZw>
[image: Twitter] <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&usg=AFrqEzc4-Qr1r8d_c0K_9PGkw3O126J68A> [image: Blog] <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz=1&usg=AFrqEzfHybQaBaAQIalfuAv9g8QhxaEF-A> [image: Facebook] <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&sntz=1&usg=AFrqEzc4Kk2TUyZinWuhXhn5uMDEfa-TRw> [image: LinkedIn] <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1214250&sa=D&sntz=1&usg=AFrqEzezWUya7565tGaMEx0C4Mu7a0Gjcg> [image: Google+] <https://plus.google.com/117544963211695643458/posts>
Hi, Andrew! On Sep 17, Andrew Braithwaite wrote:
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.
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
After dropping tables on my MariaDB 10.0.13 database server, the .frm files are removed but the .ibd files remain behind. Has anyone seen this before?
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