Repair by sorting?

Question

I have a script that updates localhost and then deletes the updated results on remotehost:

mysqldump --skip-tz-utc --no-create-info --insert-ignore --host=localhost -u u -ppass db table --where=\"timeStamp > FROM_UNIXTIME( $time )\" | mysql -h remote -u u -ppass db

With 20 entries, updating to localhost is very fast (a few seconds), but the dump for the remote host takes more than 4 minutes ... when I look at the mysql workbench, it says that the state of the remote host is "Repair by Sort" and the Info column " / *! 40000 ALTER TABLE 'table' ENABLE KEYS * / ".

What does this message mean (and why has it been taking so long for a remote host with so many entries)?

THX

Answer 1

mysqldump , . , , , , .

--skip-disable-keys mysqldump, .

Answer 2

mysqldump

;

ENABLE KEYS;

.

.

ENABLE KEYS "Repair By Sorting";

DISABLE KEYS ENABLE KEYS, , , - . MySQL, .

, -skip-disable-keys, "", .

, MyISAM. InnoDB DISABLE KEYS ENABLE KEYS.