Running identical queries in sysbench

Posted on

Question :

When benchmarking using sysbench and utilizing concurrency (multiple threads) for example on a table with 1,000,000 records, does sysbench run “identical” queries in a loop on the table?

Answer :

You can create several test types with sysbench, but if you look at the typical OLTP tests for SELECTS and INSERTS you will see that the queries executed are similar in pattern, but with random values for each query (not identical every time).

If they were identical (something that you could test if you wanted), structures like the query cache and buffer pool would be very effective, invalidating the reason for the stress test.

Leave a Reply

Your email address will not be published. Required fields are marked *