From: "Jiri Matejka" <[EMAIL PROTECTED]> > Now I found one more "strange" thing - if I use show tables to get table > properties, then if table is MyISAM the number of rows is correct and if it > is InnoDB number of rows is around 2000 lower... And the innodb table looks > 8 times bigger than myisam table (field data_length in show table status > query)... Nothing "strange", since it's documented. InnoDB gives an estimate of the number or rows in a table. Since MyISAM keeps a seperate count of the number of records, it can give you accurate numbers.
Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]