View Single Post
  #1  
Old 11-29-2006, 06:50 AM
Slezley Slezley is offline
Junior Member
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Slezley is on a distinguished road
Default incorrect records...

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 --
Reply With Quote
  Webmaster Forums - View Single Post - incorrect records...
View Single Post
  #1  
Old 11-29-2006, 06:50 AM
Slezley Slezley is offline
Junior Member
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Slezley is on a distinguished road
Default incorrect records...

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 --
Reply With Quote