incorrect records...

[Slezley]

Hi,
Recently I found that SELECT COUNT(*) FROM table returns incorrect number of records in a table. Defragmenting a table fixes it, but it takes much time. Anyone knows if it is a common problem in InnoDB engine?
thank you! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Renne]

Try to make a repeatable test case. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --