Re: Merging multiple SQL requests

2015-02-23 Thread Johan De Meersman
- 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

Re: Merging multiple SQL requests

2015-02-22 Thread Learner Study
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

Re: Merging multiple SQL requests

2015-02-21 Thread Jay Ess
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

Re: Merging multiple SQL requests

2015-02-17 Thread Bob Eby
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.

Re: Merging multiple SQL requests

2015-02-16 Thread Johan De Meersman
- 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

Re: Merging multiple SQL requests

2015-02-15 Thread Stewart Smith
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

Re: Merging multiple SQL requests

2015-02-15 Thread Learner Study
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

Merging multiple SQL requests

2015-02-15 Thread Learner Study
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:

Re: Merging multiple SQL requests

2015-02-15 Thread Stewart Smith
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