From: Rahul Jha Date: September 24 2012 11:36am Subject: Issue while converting a table from MyISAM to InnoDB List-Archive: http://lists.mysql.com/innodb/65 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf3074b3e0319a8904ca710172 --20cf3074b3e0319a8904ca710172 Content-Type: text/plain; charset=ISO-8859-1 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 --20cf3074b3e0319a8904ca710172--