D]>
To:
Sent: Tuesday, July 25, 2006 11:51 PM
Subject: Re: Row count discrepancy when converting from MyISAM to InnoDB
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be d
nt: Tuesday, July 25, 2006 11:51 PM
Subject: Re: Row count discrepancy when converting from MyISAM to InnoDB
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of
Thank you to everyone who replied. It turned out I had index corruption and
after running an OPTIMIZE TABLE I was able to convert all the records to
InnoDB.
Thanks,
Frank
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of this many rows?
InnoDB doesn't keep a count on number of rows, like MyISAM does.
InnoDB only main
