G
George Potemkin
Guest
Addition to what Keith Sudbury has wrote: carefully choose an index for dump. Dump time of the same table may vary by the tens times depending from the chosen index. But instead of option 1) I'd suggest to dump db in read-only mode. No resource locks (and no resource conflicts between sessions). And each session will use its own (small) buffer pool.
Continue reading...
Continue reading...