Re: Slow insert rate in mysql innodb

[Rick James]

Need some more info to address your question:
SHOW TABLE STATUS LIKE 'tbl_name';
SHOW CREATE TABLE tbl_name;

Probably you have too many indexes for this high INSERT rate. Ordinary disks can handle only 100 updates per second. With the CREATE table, I will discuss why you are getting only 20x that, and what to do to get 30x. (If I can.)

How long will you save the data before purging it? I assume you will be doing DROP PARTITION?

Some flavors of VM have something like 30% overhead; the 100 I mentioned refers to standalone systems.

It sounds like you will be having a huge table (terabytes); shouldn't you consider a standalone mysql server?

RAID-5 on a hardware controller, with battery-backed-write-cache is a must for your situation.