[SERVER-16037] WT show performance regression comparing to 10/31 build Created: 08/Nov/14  Updated: 11/Jul/16  Resolved: 21/Nov/14

Status: Closed
Project: Core Server
Component/s: Performance, Storage
Affects Version/s: 2.8.0-rc0
Fix Version/s: 2.8.0-rc1

Type: Bug Priority: Major - P3
Reporter: Rui Zhang (Inactive) Assignee: Rui Zhang (Inactive)
Resolution: Done Votes: 0
Labels: 28qa
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Participants:

 Description   

tested with mix traffic test with wiredtiger, build since 11-01 show 4% to 23.7% performance regression when comparing to 10-31 build.



 Comments   
Comment by Rui Zhang (Inactive) [ 21/Nov/14 ]

tested with 11-20 build

Performance comparison for 2014-11-20 vs 2014-10-30 :
=====================================================
|    | test                 |   2014-10-30 |   2014-11-20 | 2014-11-20 % vs 2014-10-30   |
|---:|:---------------------|-------------:|-------------:|:-----------------------------|
|  0 | insert               |     84174.2  |     86461.7  | 2.72%                        |
|  1 | DISTINCT_RANGE_08    |     11330.8  |     13184    | 16.36%                       |
|  2 | INDEX_UPDATES_08     |     29353.3  |     27131    | -7.57%                       |
|  3 | NON_INDEX_UPDATES_08 |     33435.9  |     33850.4  | 1.24%                        |
|  4 | ORDER_RANGES_08      |      6405.25 |      7240.1  | 13.03%                       |
|  5 | POINT_SELECTS_08     |      6222.81 |      6814.53 | 9.51%                        |
|  6 | SIMPLE_RANGES_08     |     12011.5  |     15934.7  | 32.66%                       |
|  7 | SUM_RANGES_08        |     11136.4  |     13096.1  | 17.60%                       |
|  8 | ADD_REMOVE_08        |     17874    |     17359.7  | -2.88%                       |

  • INDEX_UPDATE, which updates an indexed field is still slow for around 7.57%, I think we can close this ticket, I will do more test for INDEX_UPDATE, if there is any clear issue, I will open another ticket?
Comment by Daniel Pasette (Inactive) [ 19/Nov/14 ]

can you characterize with latest?

Comment by Eliot Horowitz (Inactive) [ 08/Nov/14 ]

How do I reproduce?

Generated at Thu Feb 08 03:39:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.