MySQL Forums
Forum List  »  Merge Storage Engine

merging large-tables
Posted by: Erhan Takmaz
Date: November 18, 2007 03:40PM

Hello,

Ive got a large database (180G). I read about partitioning but im not willing to use 5.1.
The Index of the database is too big to fit into the key_buffer (myisam-table).

Can I expect a performanceboost by dividing the table into smaler peaces and merging them together?
As far as I can see. 5.1 with partitioning could reduce the lookup to one table.
Ok I cant expect this to happen with merge, but can I expect a better performance than on a large file?

thx
erhan

Options: ReplyQuote


Subject
Views
Written By
Posted
merging large-tables
8955
November 18, 2007 03:40PM


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.