<cut>
Yan> Alternative options for not shutting down mysqld during isamchk have been
Yan> discussed on the mailinglist (but never mentioned in the manual!). This involves
Yan> combining LOCK TABLES and FLUSH TABLES. It appears that the usage and order of
Yan> the two statements may vary, depending upon whether isamchk alters the tables
Yan> or not. I saw questions being asked; some answered by the developers, others
Yan> by regular MySQL experts (like yourself) but without confirmation from the
Yan> developers. My own experiments showed that combining the 2 statements in
Yan> certain orders can crash mysqld (see my previous posts).
Yan> That's why I found myself confused, and therefore need help (I'm considering
Yan> for the extended login support, but you know the paper work being involved in
Yan> a company). Do you have a clear idea to share with me about how to use
Yan> LOCK TABLES and FLUSH TABLES so that one can run isamchk without mysqld down?
Yan> Thanks very much,
Yan> --Yan
Hi!
In 3.22.25 and 3.23, you should be able to get away by doing:
LOCK TABLES...
FLUSH TABLES;
isamchk ...
FLUSH TABLES;
UNLOCK TABLES;
We have not documented this as FLUSH TABLES this didn't work on
previous MySQL versions in all context and we are currently working on
getting myisamchk integrated into mysqld..
Regards,
Monty
