Re: Row Count Discrepency

2006-01-01 Thread Terry Riley 
- Original Message -

 I have an InnoDB table in a MySQL 4.1.14 database.   Can anyone suggest 
 why MySQL Adminstrator says the table has 497 rows, while doing a query 
 or a count on the same table shows that it only has 434? 
 

IIRC, InnoDB only gives an estimated row count in admin (or SQLyog or 
whatever), not an actual count, because of the way it does (or doesn't) 
store row information.

MyISAM tables, on the other hand, show accurately because they store the 
rowcount as part of the table data.

Terry

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Row Count Discrepency

2006-01-01 Thread William Allaire 
Some more information can be found here:

http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html



On 12/31/05 7:29 PM, JJ [EMAIL PROTECTED] wrote:

 I have an InnoDB table in a MySQL 4.1.14 database.   Can anyone suggest
 why MySQL Adminstrator says the table has 497 rows, while doing a query or
 a count on the same table shows that it only has 434?
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Row Count Discrepency

2005-12-31 Thread JJ 
I have an InnoDB table in a MySQL 4.1.14 database.   Can anyone suggest 
why MySQL Adminstrator says the table has 497 rows, while doing a query or 
a count on the same table shows that it only has 434? 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]