[Maria-discuss] Questions to temporary myisam table files
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. Thanks Sebastian
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
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
Hi, Sebastian! On Mar 20, Hempel, Sebastian wrote:
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?
Right, missed that, sorry. I don't think you're seeing tablename.myd-date or tablename.myd.bak, you're seeing tablename.myd-datetime.bak These come either from using myisamchk with the --backup option or from starting the server with BACKUP (or BACKUP_ALL) in the --myisam-recover-options option. Regards, Sergei Chief Architect MariaDB and security@mariadb.org
participants (2)
-
Hempel, Sebastian -
Sergei Golubchik