u/Big_Length9755

Hi,

Its Mysql aurora database. We are having an OLTP application which is hosted on this mysql database, this is going to be write heavy with additional futue workload. We want to see what maximum TPS this can accomodate on this system. I understand the TPS varies from system to system based on what a transaction means etc.

However, I want to understand if any specific parameters we should tweak or statistics/metrics we should look after , for the write heavy workload testing in a mysql database to perform at its best? Any obvious issues or contention points which we should be aware of during this? Need guidance here.