Yes your right dilip , but it wont help for INNODB .
INNODB , Rows ( show table status\G ) value is an approximation, and
may vary from the actual value .Since innodb doesnt keep track on record
count
For innodb use |SELECT COUNT(*)| to obtain an accurate count.Correct me
if iam wrong
-
Praj
Dilipkumar wrote:
Hi,
Instead of using select count(*) from tablename
You can try with show table status like 'tablename' This doesn't takes
much longer time.
Thanks & Regards
Dilipkumar
----- Original Message ----- From: "David Hillman"
<[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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 done to avoid loss of this many rows?
InnoDB doesn't keep a count on number of rows, like MyISAM does.
InnoDB only maintains an estimate of the number of rows in each
table. This is why "select count(*) from table" takes a long time
on big InnoDB tables. Usually the InnoDB count will be off by 50%
or so.
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
--
David Hillman
LiveText, Inc
1.866.LiveText x235
********** DISCLAIMER **********
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable
law. If this is a forwarded message, the content of this E-MAIL may
not have been sent with the authority of the Company. If you are not
the intended recipient, an agent of the intended recipient or a
person responsible for delivering the information to the named
recipient, you are notified that any use, distribution, transmission,
printing, copying or dissemination of this information in any way or
in any manner is strictly prohibited. If you have received this
communication in error, please delete this mail & notify us
immediately at [EMAIL PROTECTED]
Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in
Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com
