[MDEV-10084] SQL batch united response Created: 2016-05-19  Updated: 2016-07-04  Resolved: 2016-07-04

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: 10.2.2

Type: Task Priority: Major
Reporter: Oleksandr Byelkin Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-9947 COM_MULTI united response Closed
Sprint: 10.2.2-1

 Description   

Put all OK packets in one physical packet for usual SQL batch separated with ';'.



 Comments   
Comment by Oleksandr Byelkin [ 2016-06-29 ]

Even on mysql-test test 8% speedup visible.

Comment by Oleksandr Byelkin [ 2016-06-29 ]

revision-id: 85d3bb41f209433f6d517cc00aa84685e9d7a75e (mariadb-10.2.0-93-g85d3bb4)
parent(s): 8bec9746f0d5b363f385713035ca3f2daff34e1c
committer: Oleksandr Byelkin
timestamp: 2016-06-29 16:29:06 +0200
message:

MDEV-10084: SQL batch united response

Send OK of SQL batch in one packet

Comment by Vladislav Vaintroub [ 2016-07-04 ]

Looks good. Suggest to change change comment slightly to reflect the change, like

Send multiple OKs for SQL batch in one go
or

Reduce number of network send() calls for batch update requests

Generated at Thu Feb 08 07:39:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.