MySQL Forums
Forum List  »  Performance

Re: Questions about performance for huge table (100M+ rows)
Posted by: Rick James
Date: January 03, 2009 04:58PM

I'll second Vince's " A really scalable system isn't just about tuning the software and operations, its also about tuning the product, and making sure the value being offered is worth the cost of offering it. "

Vince, if I recall correctly, here are a few clarifications on your #5 comments...

* Tmp tables first try to be MEMORY. In doing so, VARCHAR are automatically turned into CHAR. Hence, this eliminates that reason for suggesting that a table with variable length fields should use CHAR.

* TEXT/BLOB (if one selects that column) disallow the use of MEMORY, and it goes straight to MyISAM.

Options: ReplyQuote

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.