in my VPS mysql server I can't access anymore a table, a simple
select count(*) from table
doesn't work (makes me wait for minutes without answering).
If I run:
show open tables from mentorfm where in_use = 1;
I see the table, but with "name_locked" to 0
I guess the problem was in a massive insert script I run during the night, this morning for some reason I found it stopped...the script has a START TRANS at the very beginning and a COMMIT at the end and it takes hours to be executed, but normally the execution continue until the end.
What can I do with this table?