SELECTS per second per thread/core vs. MariaDB in Memory

Help Query Tuning
1

I’m failing to achieve the desired 10,000, beyond 1,300 per second things tail off and go wonky (timing for each select starts to vary). Any ideas on what can help? Using a simple small table < 100 rows, 2 parameter simplest SELECT with a key on RowStore. 1 Master and 1 Leaf (dedicated 6 Core/18 Gb)

All help appreciated?

2

What’s your goal? Are there concurrent updates? Why is the table so small?

Please provide the query and the CREATE TABLE statement and any CREATE INDEX statements, if they exist.

And how many partitions does the database have?