Re: Slow insert rate in mysql innodb

[Dhinakaran Arumugam]

Thanks for your reply Rick. Sorry i was sick couldn't reply on time.



> KEY `host` (`host`,`priority`,`suppression_flag`)
Currently up to 54 bytes. Changing to MEDIUMINT+ENUM+ENUM = 5 bytes.

>> I'm doing this change and let you know the results.

how many distinct `host`s are there?
>> 200 - 300 Avg, Max 1000.

How many rows do you anticipate in a 1-day PARTITION?
>> Expecting 4000 records per sec (4000 * 60 * 60 * 24 = 345 million) records expected to be inserted, but current rate only 216millin are inserted.

> How big is errorname & message?
>> Errorname and message cab be more than 4000 chars, but we wanted to store only 4000 chars, even if the original is bigger.



Edited 1 time(s). Last edit at 02/11/2014 10:34PM by Dhinakaran Arumugam.