On Tue, Nov 24, 2009 at 10:17 PM, Anthony wikimail@inbox.org wrote:
On Tue, Nov 24, 2009 at 7:57 PM, Domas Mituzas midom.lists@gmail.com wrote:
Antony writes:
If it is, you'd probably want to use partitioning
Partitioning makes selects faster only when there's parallel execution on multiple partitions at once.
[snip] I have no idea how this works on MySQL, or if it works on MySQL at all. In MySQL, you could achieve the same thing through clustering, however.
http://dev.mysql.com/doc/refman/5.1/en/partitioning-pruning.html
"When the optimizer can make use of partition pruning in performing a query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and data. "
I don't see any mention of "parallel execution", and I don't see why that would be necessary to benefit from partitioning.