Recovering the BIG table

[Rajasekhar Raju Muppala]

Hi All,

I executed the below step to recover one of the crashed table in my MySql Database, which is having 140 GB size.

mysql> recover table table_name;

It is running since 8 days...

Now, I want to know whether the query is processing in background or not and I had checked in PROCESSLIST, which is showing the TIME and STATE as Repair by Sorting.

Also, I had checked in Global Status, here I observed that, handler_read_rnd_next column is getting increased every time (approx: 9 crores).

Kindly help me to find out a way to check still how many records need to be processed

Thanks in advance...


Rajasekhar