So I have to maintain a legacy system that has millions of rows in a MySQL myisam table.
Once in a blue moon, the UPS or the power supply craps out, and crashes the server and hence the tables will be autoatically repaired at next use. This can take an hour or more.
Is there a way to transparently move historical data from the table to another maybe read-only table which will not be marked as crashed when things go wrong? If the REPAIR would only have to deal with e.g. last year's data, it would be way quicker.
My problem i that the SELECTs would stil have to be able to take into account all data from all times (like transparent a UNION or "view").