← Back to team overview

maria-discuss team mailing list archive

Re: .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@xxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> 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>
>

Follow ups

References