Robbie2003
IS-IT--Management
I have used the repair table option to try and repair a table that has crashed, this did not seem to work it was suggested that i use the following option.
REPAIR TABLE wrm_tellafriend EXTENDED
I have used this option but I am not sure if it is working or not after entering this command a statment appeared about two minutes later saying NO SQL I have left the system to run over night and on checking this morning it would seem that the system is still repairing the table (I would expect the table to take a long time to repair as thier is sixteen million records in it).
I have checked the process list and the first line is the repair query that I startded, am I right in thinking that the repair is working and that it has just not finished yet? also under this first line repair query thier are several other queries appearing stating "Waiting for table" should I just kill these queries off?
Below is a copy of the process list.
Databases
Processes
Export
Process list
ID User Host Database Command Time Status SQL-query
Kill 11 wrm localhost wrm Query 44850 Repair with keycache REPAIR TABLE wrm_tellafriend EXTENDED
Kill 188 wrm localhost wrm Query 287 Waiting for table UPDATE wrm_tellafriend SET has_unsubscribed =1 WHERE address = 'bradkb@tpg.com.au' LIMIT 1
Kill 190 wrm localhost wrm Query 4 Waiting for table SHOW TABLE STATUS FROM `wrm`
Kill 193 wrm localhost None Query 0 --- SHOW PROCESSLIST
REPAIR TABLE wrm_tellafriend EXTENDED
I have used this option but I am not sure if it is working or not after entering this command a statment appeared about two minutes later saying NO SQL I have left the system to run over night and on checking this morning it would seem that the system is still repairing the table (I would expect the table to take a long time to repair as thier is sixteen million records in it).
I have checked the process list and the first line is the repair query that I startded, am I right in thinking that the repair is working and that it has just not finished yet? also under this first line repair query thier are several other queries appearing stating "Waiting for table" should I just kill these queries off?
Below is a copy of the process list.
Databases
Processes
Export
Process list
ID User Host Database Command Time Status SQL-query
Kill 11 wrm localhost wrm Query 44850 Repair with keycache REPAIR TABLE wrm_tellafriend EXTENDED
Kill 188 wrm localhost wrm Query 287 Waiting for table UPDATE wrm_tellafriend SET has_unsubscribed =1 WHERE address = 'bradkb@tpg.com.au' LIMIT 1
Kill 190 wrm localhost wrm Query 4 Waiting for table SHOW TABLE STATUS FROM `wrm`
Kill 193 wrm localhost None Query 0 --- SHOW PROCESSLIST