Web lists-archives.com

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:
 * traceroute
 * ping
 * 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.
> 
> Thanks

-- 
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