Bug #90700 Return X protocol resultset rows in blocks instead of individual packets
Submitted: 30 Apr 2018 18:25 Modified: 30 Sep 2020 13:06
Reporter: Jason Rahman Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Connection Handling Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[30 Apr 2018 18:25] Jason Rahman
The X protocol sends rows in resultsets in individual packets, rather than grouping them into packets containing blocks of rows.

How to repeat:
Documentation indicates one row is sent per packet.

Suggested fix:
Change the resultset format so that instead of returning a single row per X protocol packet, return a special row-block packet that contains multiple rows in a single X protocol packet. This would allow proxies to forward entire blocks of rows without iterating over all rows.
[30 Sep 2020 13:06] MySQL Verification Team
Hi Mr. Rahman,

This looks like a valid feature request.

Verified as reported.