[MDEV-9871] benchmark the 10.2 fast-connect tree Created: 2016-04-05 Updated: 2017-06-13 Due: 2016-04-22 Resolved: 2017-06-13 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Fix Version/s: | 10.2.6 |
| Type: | Task | Priority: | Minor |
| Reporter: | Axel Schwenke | Assignee: | Axel Schwenke |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
| Description |
|
Source tree is bb-fast-connect (based on 10.2). Montys results follow All tests with run with storage engine MyISAM (to get predictable results):
|
| Comments |
| Comment by Axel Schwenke [ 2017-06-13 ] |
|
This task was delayed and 10.2 fast-connect has long since been merged with the 10.2 main tree. Hence I did not test fast-connect vs. 10.2 (before merge) but rather test different MariaDB server versions. In 10.2 the connect performance is about 3x as fast as in earlier versions (tested: 5.5 to 10.1). That however comes partly from the fact that the thread cache is by default enabled in 10.2 but was disable in earlier versions. If the thread cache is set to 64, then 10.2 is still 2x faster than previous versions. For details check the attached spread sheet. |