MySQL Forums
Forum List  »  MyISAM

What constitutes a large table?
Posted by: Kenneth Vogt
Date: October 10, 2005 08:24PM

I have a table that has regular inserts made to it, no updates ever, and infrequent deletions. That is, it may have 50,000 inserts a day for a week before anything is deleted. This table has held up to 1,500,000 rows. From what I read about benchmarks, mysql should be able to handle a table 100 times this size. And yet the indexes seem to get corrupted easily. Is there some way to avoid this corruption problem? Is it a performancing tweaking issues? What oh what am I doing wrong?

Options: ReplyQuote


Subject
Views
Written By
Posted
What constitutes a large table?
2945
October 10, 2005 08:24PM
1924
October 17, 2005 01:22PM
1992
October 17, 2005 03:17PM
1989
October 18, 2005 10:42AM
1946
October 18, 2005 12:12PM
2012
October 19, 2005 01:27AM
1946
October 19, 2005 09:10AM
1933
October 20, 2005 01:26AM


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.