maria-discuss team mailing list archive

["Hempel, Sebastian" <Sebastian.Hempel@xxxxxxxxx>]

Hi Sergei,

thanks a lot for the fast answer.

>From time to time we see tablename.myd-date or tablename.myd.bak files where are these coming from?

Thanks

-----Ursprüngliche Nachricht-----
Von: Sergei Golubchik [mailto:serg@xxxxxxxxxxx] 
Gesendet: Freitag, 17. März 2017 13:45
An: Hempel, Sebastian <Sebastian.Hempel@xxxxxxxxx>
Cc: maria-discuss@xxxxxxxxxxxxxxxxxxx
Betreff: Re: [Maria-discuss] Questions to temporary myisam table files

Hi, Hempel,!

On Mar 17, Hempel, Sebastian wrote:
> Hallo,
> 
> there is a known issue with the repair table function (MDEV-5871, 
> MDEV-8475), which was fixed in MariaDB 10.  Which is fine, but we have 
> still MariaDB 5.5 server running.
> 
> So we created our own repairtable function to work around this 
> problem.  For that function I like to know all possible file 
> extensions for temporary myisam table files.  For me temporary myisam 
> table files are these files which are generated when calling "check 
> table", "repair table" or other database functions.

That's what I'm getting:

$ grep -ho '"\.[A-Z]\+"' -rI storage/myisam|sort -u ".MYD"
".MYI"
".OLD"
".TMD"
".TMM"

The first two are for normal tables, the other three must be used for temporary tables.

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx