Re: Calculate hardware needs based on desired writes per second

[Aftab Khan]

You are likely to observe data load speed to decrease over the period of time. because of secondary indexes. I would advise you to consider adding more memory to the server? i.e double it from 24GB to 48GB and increase innodb buffer pool size from 16GB to 32GB.

The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the data from memory during subsequent reads. The buffer pool even caches data changed by insert and update operations, so that disk writes can be grouped together for better performance.