A
Andriy Mishin
Guest
[quote user="ChUIMonster"] The fastest way to dump the table is probably a binary dump with index 0. If you can get that done reasonably close to your down time window then you might be able to do a more or less "normal" d&l. A lot will depend on what you have available for HW resources. [/quote] As I understand it, you mean a binary dump with multiple threads + index 0. 1. Run binary dump in parallel with multiple tables. 2. Copy the dump files to another server. 3. Load these files to a new database without build indexes. 4. Run idxbuild. I think that it will still take more time than I will have. What you mean by "available for HW resources"? HDD, CPU, RAM?
Continue reading...
Continue reading...