MySQL Forums
Forum List  »  MySQL & Storage

Re: MySQL + NAS(NFS or CIFS) + Huge Table Insert Problem (Long)
Posted by: JinNo Kim
Date: September 20, 2005 06:19AM

I will start visiting, thanks! The dataset broke 2 billion rows while I was doing the splitting and is still growing on the daily MyISAM tables. Using packed keys (had the opportunity to play while restructuring DB) and compressing the older daily tables, I should be able to get an insane amount of data on to our systems before having to prune for space reasons.

An added benefit to splitting into daily MyISAM tables is that we are noticing distinct patterns to the distribution of the rows (an added benefit) :).

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL + NAS(NFS or CIFS) + Huge Table Insert Problem (Long)
September 20, 2005 06:19AM


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.