MySQL Forums
Forum List  »  InnoDB

strange table status - row count varying
Posted by: Alex Bruckert
Date: April 13, 2005 03:23AM

Hi There,

i have an innodb table for member accounts with about 75.000 records - i backuped this table (with phpmyadmin) into a second table accounts_backup ... now if i do a show table status the record sets on both innodb tables are varying with every refresh ... select count(id) or select max(id) is stable / gives the same output everytime ...

its a mysql 4.1.10 on a debian system - installed with apt-get

anyone has any idea?

Options: ReplyQuote

Written By
strange table status - row count varying
April 13, 2005 03:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.