Bug #56308 Poor Insert Performance
Submitted: 26 Aug 2010 19:28 Modified: 28 Aug 2010 5:29
Reporter: Jamie Koc Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S5 (Performance)
Version:5.1.42 OS:Linux
Assigned to: CPU Architecture:Any
Tags: bulk insert, insert performance

[26 Aug 2010 19:28] Jamie Koc
I am experiencing very slow insert performance while doing an INSERT ... VALUES (...), (...), ..., The average throughput is about 3500 inserts / sec. Our process takes a file (usually around 20M of data) and converts it to this insert ... values() statement. It is taking between 20-30 seconds to load 80K records. The server is dedicated to processing this data so no other processes are running. The table I am inserting into has 2 btree indexes. I do not have the option of using load infile.

Are there configuration settings I can change to improve performance?

How to repeat:
Here are my key configuration parameters:

key_buffer_size = 2147483648 
bulk_insert_buffer_size = 67108864
read_buffer_size = 4194304
sort_buffer_size = 2147483648

I am running a 4 CPU core with 32G of memory.
[27 Aug 2010 4:48] Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.
[28 Aug 2010 5:29] Jamie Koc
What's the phone # to call tech support?
I can't find it anywhere