MySQL Forums
Forum List  »  Partitioning

Re: Partitioning performance issues // 5.1
Posted by: Mattias Jonsson
Date: February 19, 2010 04:17AM

This is partly because of bug#37252, i.e. the overhead of open and locking all partitions before pruning.

For inserts the work is about the same for a partition as for a table, you can in theory get a small performance gain, since the indexes in the partition is smaller, the depth in an index is usually O(log(n)).

The primary gain of partitioning is to ease the management of data, i.e. group data in different partitions and then add and drop partitions quickly etc. And to use pruning to skip partitions that can not satisfy the WHERE clause to search through less data.

Partitioning also opens up the possibility to implement parallelism in queries of big tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
3959
February 17, 2010 10:53AM
Re: Partitioning performance issues // 5.1
2377
February 19, 2010 04:17AM
2203
February 19, 2010 10:11AM


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.