Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

edit:

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

share|improve this question
    
Are you running the import process on the server, itself, or remotely? Are you using the mysql command line client, or something else? –  Michael - sqlbot Mar 4 at 2:52
    
I began the process via SSH, then disowned and backgrounded it so it wouldn't be interrupted when I log out –  BradStevenson Mar 4 at 7:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.