MySQL Forums
Forum List  »  Performance

Re: Millions storage...
Posted by: James Day
Date: April 01, 2005 09:09PM

Any gaps in the sequence of ids in the table? Normal to see gaps if you're adding and deleting records.

On your production system, what are the results of the same queries? What does SHOW TABLE STATUS say on both? Note that the row counts for show table status in InnoDB are approximate, so don't rely on them - it's the MyISAM version which is of most interest to me.

It's not impossible for a damaged database to have problems during optimize or conversion operations but it's probably only the ids autoincrementing beyond the actual number of rows.

Since there is a chance that the data you're copying form may be damaged, best to make a backup of your production data. Use caution here, because there are situations in which repair table on a badly damaged table can lose records which a backup can read. Better to have the backup first, just in case you encounter one of those situations. I doubt this is happening but protecting your data matters, even if the chance is low.

Options: ReplyQuote


Subject
Views
Written By
Posted
1763
March 28, 2005 07:53PM
1753
March 30, 2005 12:50AM
1792
March 30, 2005 01:16AM
1980
April 01, 2005 12:51AM
1756
March 31, 2005 11:34PM
1814
April 01, 2005 09:07AM
Re: Millions storage...
1857
April 01, 2005 09:09PM


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.