Re: Strange observation in "OPTIMIZE TABLE" command in InnoDB

2014-09-08 Thread wagnerbianchi.com
Are both instances running the same MySQL version and release? Are they MASTER and SLAVE, actively replicating? Are the InnoDB configurations currently running on both servers the same? -- *WB* 2014-09-06 6:00 GMT-03:00 Ajay Garg : > Sorry, forgot to specify the engine. > The table runs on InnoD

Strange observation in "OPTIMIZE TABLE" command in InnoDB

2014-09-06 Thread Ajay Garg
Sorry, forgot to specify the engine. The table runs on InnoDB backend. Also, changed the subject to be more specific. On Sat, Sep 6, 2014 at 2:26 PM, Ajay Garg wrote: > Hi all. > > > We are facing a very strange scenario. > > We have two mysql-instances running on the same machine, and they had