Bug #53852 InnoDB: Performance drop in SELECT_SUM_RANGES test at higher number of threads
Submitted: 20 May 2010 11:14 Modified: 8 Dec 2010 22:45
Reporter: Alexey Stroganov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S3 (Non-critical)
Version:5.1.47/plugin1.0.8 OS:Any
Assigned to: Alexey Stroganov CPU Architecture:Any

[20 May 2010 11:14] Alexey Stroganov
Description:
While running sysbench SELECT_SUM_RANGES test for 5.1.47/iplugin-1.0.8 we have observed slight drop in performance ~128/256 threads.

# Test: SELECT_SUM_RANGES:throughput, TPS
#
# Server 1 - 5.1.46-plugin-1.0.7
# Server 2 - 5.1.47-plugin-1.0.8
#
#             Server 1  Server 2
# Thread        INNODB    INNODB
          4   25183.79  24812.62
         16   41539.69  41534.32
         64   37017.63  36054.03
        128   35743.26  34929.75
        256   35883.04  34652.39

How to repeat:
Run sysbench/SELECT_SUM_RANGES test for 5.1.46/iplugin107 and 5.1.47/iplugin108