We have some performance issues with one of our Test-Machines a MySQL 5.7.21 Standalone Server.
We have: 8 CPUs 16GB RAM (
buffer_pool_size 5.6 G) and need to handle > 30 K Requests / minute.
When we run our tests the CPU workload raised to 100% and we got several issues (long query run time etc...)
What is your hardware recommendation for this workload? ty in advance br Andreas