Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
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.
Attachments
Issue Links
- relates to
-
MDEV-19515 Improve connect speed
-
- Open
-
<montywi> XL: I update the bb-fast-connect tree in git; This is after serg's review
<montywi> so I only need you to verify that things are same or better than normal 10.1 for connect tests and I can push
<XL> montywi: I see
<montywi> on my machine, having all threads in the thread cache gives a 5% speed increase; Having no thread cache was about the same
<montywi> this was when running 32 perl processes on the same machine to connect, do a query and disconnect
<montywi> doing this with a threaded benchmark should hopefully show a bigger speed increase