Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
    
mysqltuner.com try this out –  neolix Mar 12 '12 at 7:21
add comment

1 Answer 1

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

share|improve this answer
add comment

Your Answer

 
discard

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.