RE: Query on some MySQL-internals

2014-09-07 Thread Martin Gainty
__ > Date: Sun, 7 Sep 2014 23:06:09 +0530 > Subject: Re: Query on some MySQL-internals > From: ajaygargn...@gmail.com > To: mgai...@hotmail.com > CC: mysql@lists.mysql.com > > Hi Martin. > > Thanks for the reply. > &

Re: Query on some MySQL-internals

2014-09-07 Thread Ajay Garg
sh_ci Checksum: NULL Create_options: partitioned Comment: 1 row in set (0.24 sec) Thanks and Regards, Ajay On Sat, Sep 6, 2014 at 8:06 PM, Martin Gainty wrote: > > > > >> Date: Sat, 6 Sep 2014 14:26:22 +0530 >> Subject: Query on some MySQL-int

RE: Query on some MySQL-internals

2014-09-06 Thread Martin Gainty
> Date: Sat, 6 Sep 2014 14:26:22 +0530 > Subject: Query on some MySQL-internals > From: ajaygargn...@gmail.com > To: mysql@lists.mysql.com > > Hi all. > > > We are facing a very strange scenario. > > We have two mysql-instances running on the same mac

Query on some MySQL-internals

2014-09-06 Thread Ajay Garg
Hi all. We are facing a very strange scenario. We have two mysql-instances running on the same machine, and they had been running functionally fine since about 6 years or so (catering to millions of records per day). However, since last few days, we were experiencing some elongated slowness on