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 ajaygargn...@gmail.com: Sorry, forgot to specify the engine.

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 ajaygargn...@gmail.com wrote: Hi all. We are facing a very strange scenario. We have two mysql-instances running on the same