Re: Merging multiple SQL requests
- Date: Mon, 16 Feb 2015 11:40:00 +0100 (CET)
- From: Johan De Meersman <vegivamp@xxxxxxxxx>
- Subject: Re: Merging multiple SQL requests
...it sounds to me like you're trying to figure out the small things when there's probably an elephant standing around somewhere :-)
You can quickly see if your network is troublesome using:
* network copy (ssh/nfs/samba/whatever) of a large file
Usually, however, it's not the network :-)
Open up a console on your server and run dstat, see what resources are being taxed. Turn on the slowlog at 1s (or even 0s) and use pt-query-digest to figure out what queries are slow. Profile your application to see which bit takes longest to execute.
----- Original Message -----
> From: "Learner Study" <learner.study@xxxxxxxxx>
> To: "Stewart Smith" <stewart@xxxxxxxxxxxxxxxxxx>
> Cc: "MySql" <mysql@xxxxxxxxxxxxxxx>, "internals" <internals@xxxxxxxxxxxxxxx>
> Sent: Monday, 16 February, 2015 02:07:45
> Subject: Re: Merging multiple SQL requests
> 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 ticks etc. Is there anything else
> to watch out for..pointers would be appreciated.
Unhappiness is discouraged and will be corrected with kitten pictures.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql