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

Written By
March 28, 2005 07:53PM
March 30, 2005 12:50AM
March 30, 2005 01:16AM
April 01, 2005 12:51AM
March 31, 2005 11:34PM
April 01, 2005 09:07AM
Re: Millions storage...
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.