On Tue, Nov 24, 2009 at 10:17 PM, Anthony <[email protected]> wrote: > On Tue, Nov 24, 2009 at 7:57 PM, Domas Mituzas <[email protected]> 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. _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
