MySQL Forums
Forum List  »  Partitioning

A first table partitioning exercise.
Posted by: patrick flaherty
Date: December 01, 2010 06:15PM

Experienced programmer but without a lot of MySql experience.

This seemed like a good exercise to try out table partitioning in MySql:

A time difference of an order of magnitude (3.88 partitioned sec vs 38.30 sec) seems pretty compelling.

So I go through exactly the same exercise and get:

(unpartitioned) 5.09 sec vs (partitioned) 3.82 sec.

Partitioned matches closely but unpartitioned has come way down. Why? I would guess because I'm using a fairly recent version of 5.5 whereas the exercise was written for 5.1 and various things have occurred to considerably improve the unpartitioned performance between 5.1 and 5.5?

I wonder what those things might be (provided I'm correct of course)? And it would be useful to have an example that better demonstrates differences between partitioned and unpartitioned for 5.5 (?).

Options: ReplyQuote

Written By
A first table partitioning exercise.
December 01, 2010 06:15PM
December 02, 2010 11:00PM

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.