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
1960
March 28, 2005 07:53PM
1929
March 30, 2005 12:50AM
1965
March 30, 2005 01:16AM
2190
April 01, 2005 12:51AM
1940
March 31, 2005 11:34PM
2013
April 01, 2005 09:07AM
Re: Millions storage...
2030
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.