Re: Need to insert 10k records into table per second

[Cecil none]

Thanks a lot for all the pointers.

I've also been reading this: http://kvz.io/blog/2009/03/31/improve-mysql-insert-performance/

So next I will try doing a transaction to wrap 500 or 1000 inserts at a time.
Is that the best/normal way for inserting multiple records at a time?

The problem with the info is that it comes in one line at a time, nothing is batches and we really need each line stored separately.
Unfortunately we can't summarize the data, we need to be able to see who did what and when.