MySQL Bugs: #56308: Poor Insert Performance

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:	None
Category:	MySQL Server	Severity:	S5 (Performance)
Version:	5.1.42	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	bulk insert, insert performance

Description:
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.

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.

What's the phone # to call tech support?
I can't find it anywhere