Recovering the BIG table
Posted by: Rajasekhar Raju Muppala
Date: December 12, 2016 08:44AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Recovering the BIG table
314
December 12, 2016 08:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.