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@mariadb.org] Gesendet: Freitag, 17. März 2017 13:45 An: Hempel, Sebastian <Sebastian.Hempel@leutek.de> Cc: maria-discuss@lists.launchpad.net 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@mariadb.org