Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone suggest an optimal setting for what I'm doing? (Note that this is a one time job, after finishing my code, I'll put this back to development setting.)

I am setting up a 64bit Ubuntu 11.10 VM with 4 cores and 16GB RAM. I'm going to import 15MM+ rows into a single table and upon saving, the Python/Django code will trigger a look up to a second table, and pull some fields from the second table and update the large table.

The job has already failed once because I was trying to import 15MM+ in one short. So I have broken the file down into 16 files.

There will be some filtering and export off the first table after the import is completed.

The DB is InnoDB. I don't know how good the default my-large or my-huge .cnf settings are and not sure if it is suitable at all for me.

Thank you in advance!

share|improve this question try this out – neolix Mar 12 '12 at 7:21

try this or this. both should give you some sane configuration values suitable for modern hardware.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.