From: Paul Wilson Date: September 24 2012 7:30pm Subject: Re: Issue while converting a table from MyISAM to InnoDB List-Archive: http://lists.mysql.com/innodb/66 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d04428c26d7655104ca779dbf --f46d04428c26d7655104ca779dbf Content-Type: text/plain; charset=ISO-8859-1 unsubscribe On Mon, Sep 24, 2012 at 6:36 AM, Rahul Jha wrote: > Hi, I have found this difference while converting one of the table from > MyISAM to InnoDB engine. I am giving you the differences what i noticed. > Could you please answer the possible reason for this. > *Name of the Table No of Rows Size > Engine* > Profile 367,140 > 81.0 M.B. MyISAM > Profile 366,268 > 119.2 M.B. InnoDB > > in Innodb we are getting 872 lesser rows. what could be the possible reason > for this? > P.S. we don't have any Multimedia file in this table. > > Regards, > Rahul > --f46d04428c26d7655104ca779dbf--