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:[email protected]] Gesendet: Freitag, 17. März 2017 13:45 An: Hempel, Sebastian <[email protected]> Cc: [email protected] 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 [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
