Sorry, but I really have little information for the question.
I have one MySQL MySIAM table, which contains about 80 thousand records (constantly increasing). Today, he suddenly stops responding.
I can’t even execute one request (for example SELECT * FROM table LIMIT 1), the server just wastes time on execution and looks like it never stops.
I cannot reset the table to make a backup.
However, other tables in the same database, the same engine (MySIAM) work fine.
I'm not sure where to go from here. Not sure if this is DEADLOCK or something else.
All data in this table is really important. You are directing a direction to help me determine that the problem will be truly appreciated. For example, is there any command to check the table, if it is damaged for some reason, etc.
UPDATE ::: I can not use CHECK TABLEany of them, it also takes forever runtime.
UPDATE :: I did research and came up with something about REPAIR TABLE. However, he suggested that a backup be made first. How can I not do back for this table, would it be the same to use the REPAIR command?
::::: SOLVED :::::
Cristian, SHOW PROCESSLIST;. , " tmp", .
KILL <process id> , , .
Chanon