Re: Calculate hardware needs based on desired writes per second

[Jan Bromberger]

Thanks, that helped speed up the process very much. I was not aware of the effect of this setting.

I had stated a wrong data size in my first post. It's actually larger than 512MB and I think it moved the point at which the insert rate degrades, but with the correct numbers 512MB may not be enough., I insert around 1,6 GB of data including two other, smaller tables in the daily import process.

The documentation says "The combined size of log files must be less than 4GB." Should the value a divisor of the innodb buffer pool size, like 1.6GB in my case or can I set it to 1.99GB to stay just below the constraint?