Query time taken on disk

2014-07-14 Thread Satendra
Hi there, I'm struggling to find the total time taken by a database query on the disk? As I understand when a database query start execution it takes some time inside the database engine & some time to seek the result from disk (if that is not in cache/buffer) Can anybody from the group please sug

Re: setting max_allowed_packet dynamically problem

2011-11-03 Thread Satendra
Hi there, Could anybody suggest me to understand on which conf file (my.cnf) my server is readiing. how could I find that? On Fri, Nov 4, 2011 at 2:28 AM, Claudio Nanni wrote: > All the previous hints are correct. > > I would also add: the arithmetic is only good for command line settings, > som