POSIX Asynchronous I/O benchmark with Sysbench and MySQL (InnoDB) - Test 1

 
Raw results can be found here for the 16 and the 64 threads runs .
 
Results for 2 000 000 requests on a table of 200 000 rows with 16 threads
 
16 Threads Time (s) queries / s time per request (s)
Total events transactions r/w requests deadlocks other min avg max 95%
libposix-aio 5288.831 84547.3547 378.16 6808.25 0.08 756.4 0.0086 0.0423 0.2265 0.066
librt 6665.8465 106602.5691 300.04 5402.09 0.09 600.16 0.0067 0.0533 0.6414 0.0856
noaio 6383.1672 102083.1377 313.32 5641.26 0.09 626.73 0.0061 0.051 0.2935 0.0838
 
Execution Time Time per request
Queries time
 
Results for 2 000 000 requests on a table of 200 000 rows with 64 threads
 
64 Threads Time (s) queries / s time per request (s)
Total events transactions r/w requests deadlocks other min avg max 95%
libposix-aio 8078.4696 516939.3521 247.57 4460.32 0.24 495.39 0.025 0.2585 1.1719 0.4254
librt 8859.8715 566972.5319 225.74 4079.94 1.02 452.5 0.0091 0.2835 2.0517 0.4803
noaio 8620.0981 551628.7995 232.02 4194.25 1.1 465.13 0.0089 0.2758 1.7477 0.46
 
Execution Time Time per request
Queries time



Page maintained by: Sébastien Dugué. Valid XHTML 1.0! Valid CSS!