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
Hi Martin. Thanks for the reply. As I had mentioned, we are running both the instances since last 6 years or so, and the records are inserted/deleted on both the instances. So, we did a "show table status like 'XX' \G;" on both the instances, and following are the outputs (here "XX" is

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 machine, and they had > been running functi