I have a particular task which is to maximize the concurrent performance. There is only one particular type of query, which is
select * from table where col1 between ? and ? and col2 between ? and ?
I have created a composite index for (col1, col2). The table is about 20G in size and 100 million rows
However, even in peak concurrent requests, the CPU utilization for MySQL is only 30%. I have tried various techniques like increase
innodb_buffer_pool_instances but none of them are working.
How to maximize the configuration so that it can perform such read-only query to extreme?