- Original Message -
From: Jay Ess li...@netrogenic.com
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 you get a
single
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
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 statements
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.
-
From: Learner Study learner.st...@gmail.com
To: Stewart Smith stew...@linux.vnet.ibm.com
Cc: MySql mysql@lists.mysql.com, internals intern...@lists.mysql.com
Sent: Monday, 16 February, 2015 02:07:45
Subject: Re: Merging multiple SQL requests
I meant that can MySQL server combine
Learner Study learner.st...@gmail.com 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
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
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?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Learner Study learner.st...@gmail.com 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