[MDEV-15086] Return the full 64 bits of thread ID in handshake packet Created: 2018-01-26 Updated: 2018-01-27 Resolved: 2018-01-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | markus makela | Assignee: | Unassigned |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
The Initial handshake packet only sends the lowest 32 bits of the thread ID. Taking 4 of the 6 reserved bytes into use for the rest of the thread ID will allow the full thread ID to be sent in the handshake. This removes the need to do a SELECT CONNECTION_ID() to know the real connection ID when the lower 32 bits roll over. |
| Comments |
| Comment by Vladislav Vaintroub [ 2018-01-26 ] |
|
Since it is only a technicality in the server, and there is no real need to support more that 4 billions concurrent connections at the same time, I'd rather Fix that on the server, than to change protocol to workaround the problem. MySQL fixes it in 5.7.5 with https://dev.mysql.com/worklog/task/?id=7293 |
| Comment by Vladislav Vaintroub [ 2018-01-26 ] |
|
closed in favor of |