0

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?

1 Answer 1

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.