MySQL Bugs: #90700: Return X protocol resultset rows in blocks instead of individual packets

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:	None
Category:	MySQL Server: Connection Handling	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

Hi Mr. Rahman,

This looks like a valid feature request.

Verified as reported.