| 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: | |
| 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 |
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.049 sec. using MySQL 8.4.5-u5-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
© 2025, Oracle Corporation and/or its affiliates
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