Optimal Hardware for > 30K Requests / min? 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
500 inserts per second is definitely into the area where out-of-the-box MySQL begins to have trouble.

Some things to do:


Don't trust benchmarks; use your code.
Combine one-row INSERTs into transactions.  (Much of what is limiting you to 500qps is the transaction overhead.
"Batch" inserts -- 100-1000 rows per INSERT statement gives you 10x performance improvement.
Use LOAD DATA -- also 10x (maybe more).
Switch to SSDs -- perhaps 10x faster than spinning drives.
innodb_flush_log_at_trx_commit=2 -- much faster, but less secure in a crash.
Decrease the number of indexes, especially UNIQUE, on the table.
Do not use UUIDs.
Gather data some other way (eg, MyISAM table with no indexes), then batch INSERT...SELECT....  This has the added advantage of giving you a change to efficiently do ETL transformations.
My High Speed Ingestion technique.  It involves ping-ponging between two staging tables and handles various variations (multiple connections, etc)