Hi Axel, On Thu, Feb 27, 2014 at 01:15:14PM +0100, Axel Schwenke wrote:
Hi Svoj,
you seemed to be interested in a OLTP benchmark with a single table, so here it is. yes, thanks a lot! Good to see that our results go almost inline. It is also good to see that we finally outperform 5.6.10 at higher threads count. :)
Thanks, Sergey
Axel Schwenke wrote:
Here are sysbench results for 10.0.8. I added 10.0.7 and MySQL-5.6.10 from an earlier run for comparison. The test is sysbench OLTP ro with multiple (32) tables.
Attached more results. tps.dat shows numbers for the same benchmark as above, but using a single big table. Again the normal mutexes show some benefits, but only at elevated concurrency. Mutex statistics are again in the zip files.
The other benchmark (tps1.dat) is sysbench OLTP both read-only and read-write. It also tests concurrencies from 1 to 512. This shows basically the same behavior. The benchmark was with PFS=off, so no mutex stats.
BR, XL