- Original Message -
> From: "Jay Ess"
> Subject: Re: Merging multiple SQL requests
> "UNION is used to combine the result from multiple SELECT statements into a
> single result set."
Yes, but only if your queries return the same number of fields; and yo
Thanks for the response!
Looks like the only way MySQL server would merge requests is based on
keywords used by client side, such as UNION etc. If client doesn't
specify such keyword, the server won't automatically merge multiple
requests.
I'm now profiling the MySQL code to identify the root-cau
On 2015-02-15 23:55, Learner Study wrote:
> Hello experts,
>
> Is it possible for MySQL server to automatically merge responses for
> different queries into a single response? Are there any kernel
> parameters that may dictate that?
"UNION is used to combine the result from multiple SELECT statem
Hi "Learner",
You might want to try reading about SQL JOIN and/or CLIENT_MULTI_STATEMENTS.
Using databases is all about conglomerating results, but it helps to know
the environment first.
riginal Message -
> From: "Learner Study"
> To: "Stewart Smith"
> Cc: "MySql" , "internals"
> Sent: Monday, 16 February, 2015 02:07:45
> Subject: Re: Merging multiple SQL requests
> I meant that can MySQL server combine multiple
Learner Study writes:
> I meant that can MySQL server combine multiple responses for a client
> and send a single TCP packet back to the client.
Unless there's a way to send multiple simultaneous requests, you won't
get multiple responses in one packet.
--
MySQL General Mailing List
For list a
I meant that can MySQL server combine multiple responses for a client
and send a single TCP packet back to the client.
But based on your response, I don't think that is possible - please correct?
Are there are any gothas to debug/investigate MySQL latency? I have
checked TCP tunables, kernel timer
Learner Study writes:
> Is it possible for MySQL server to automatically merge responses for
> different queries into a single response? Are there any kernel
> parameters that may dictate that?
I'm not sure what you could be meaning here... In the client protocol?
to send several responses at onc
