maria-discuss team mailing list archive
Mailing list archive
Re: Questions to temporary myisam table files
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?
Von: Sergei Golubchik [mailto:serg@xxxxxxxxxxx]
Gesendet: Freitag, 17. März 2017 13:45
An: Hempel, Sebastian <Sebastian.Hempel@xxxxxxxxx>
Betreff: Re: [Maria-discuss] Questions to temporary myisam table files
On Mar 17, Hempel, Sebastian wrote:
> 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"
The first two are for normal tables, the other three must be used for temporary tables.
Chief Architect MariaDB