MySQL Forums
Forum List  »  Partitioning

Re: Partitioning dilemma
Posted by: Philopator Ptolemy
Date: July 27, 2010 09:02AM

we can increase innodb_buffer_pool_size to 5GB.

If i understand you correctly, MySQL is smart enough to cache only the most frequently used regions of the index. not whole index, correct?

If that's the casse, then we don't really need the partitions. Archival of old data can be slow and can utilize index on date that we have for backoffice app.

Options: ReplyQuote


Subject
Views
Written By
Posted
2733
July 20, 2010 08:51AM
1556
July 21, 2010 11:58AM
1434
July 21, 2010 01:47PM
1529
July 26, 2010 11:15PM
Re: Partitioning dilemma
1376
July 27, 2010 09:02AM
1446
July 27, 2010 08:06PM


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.