I'm working with a MySQL Aurora database that supports an OLTP application expected to be write-heavy, especially with additional workloads coming in the future. I want to determine the maximum transaction per second (TPS) that this setup can handle. I know that TPS varies depending on the system and the specific nature of transactions, so I'm looking for advice on key metrics to monitor or parameters to adjust for optimizing performance. Are there specific contention points or other issues I should watch out for? Any guidance on how to effectively evaluate and approach this would be appreciated!
2 Answers
First off, definitely enable performance insights to get a handle on what's going on in your database. Running a load test will also give you a clearer picture of how much stress the system can handle. Then, use the insights from that to fine-tune any congestion points you might find. It's kind of a cycle: evaluate, adjust, and evaluate again.
For solid performance metrics, focus on tracking things like CPU usage, Disk I/O, and network throughput. If you have multiple threads performing concurrent inserts, keep an eye on contention indicators like locks and waits. These can tell you where your application might be slowing down or running into issues.
Related Questions
How To Get Your Domain Unblocked From Facebook
How To Find A String In a Directory of Files Using Linux