[MDEV-6150] Speed up connection speed by moving creation of THD to new thread Created: 2014-04-22 Updated: 2019-05-17 Resolved: 2016-02-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Fix Version/s: | 10.2.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Michael Widenius | Assignee: | Axel Schwenke |
| Resolution: | Fixed | Votes: | 3 |
| Labels: | connection, thread | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Sprint: | 10.1.6-2 | ||||||||
| Description |
|
One major bottleneck for creating a new connection is that THD is created in the thread that is handing all connections. The fix for this is to move THD creation from the connection thread to the new thread that will handle queries. |
| Comments |
| Comment by Axel Schwenke [ 2014-08-20 ] |
|
<montywi> XL: I update the bb-fast-connect tree in git; This is after serg's review |
| Comment by Michael Widenius [ 2014-09-02 ] |
|
Pushed to bb-fast-connect tree for testing. |
| Comment by Axel Schwenke [ 2014-09-02 ] |
|
Results from a short benchmark. I tested 3 scenarios
The last scenario shows advantages for the bb_fast_connect tree. The other however give better results with vanilla 10.1. Benchmark was run on lizard2 (Intel, 32 cores, 64 threads). Huge thread pool was configured. |
| Comment by Michael Widenius [ 2016-02-07 ] |
|
Pushed to 10.2. |
| Comment by Axel Schwenke [ 2016-02-19 ] |
|
Re-opened for benchmarking the effects of the change |