I'm importing a largish DB into MySQL (20tables of ~25mill records).
As expected this is taking a long time, but I'm curious as to why the process is running using only 0.000 to 0.700 %CPU and 0.87 %MEM ?
Is there anyway to force the process to use more resources? I've already tried messing around with its nice value.
Seems odd as Googling people importing large databses say they see MySQL eat up near to %100 of their CPU.
Some more info - Import has been running for 25 hours now, top shows CPU TIME as only 6:19.12 VIRT - 106832 RES - 3432 SHR - 484