MySQL Performance: MySQL => Innodb and Partitioning

Members

Help

Home

Home » Performance » MySQL » Innodb and Partitioning

Show: Today's Messages :: Show Polls :: Message Navigator

Innodb and Partitioning [message #3275]

Fri, 11 July 2008 16:02

erkules
Messages: 58
Registered: December 2007

Member

Is here some experience with Innodb and Partitioning?

I played with Partitioning and MyISAM with databases between 100G and 200G and Im quite impressed. My "trick" is not using PK or UNIQUE Keys.

Does Partitioning and InnoDB makes sense, or is the clustered index good enough?

Who uses partitioned InnoDB-tables?

Report message to a moderator

Re: Innodb and Partitioning [message #3282 is a reply to message #3275 ]

Sat, 12 July 2008 15:48

erkules
Messages: 58
Registered: December 2007

Member

Ups:
http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitati ons-partitioning-keys-unique-keys.html
RTFM Very Happy

Report message to a moderator

Re: Innodb and Partitioning [message #3475 is a reply to message #3275 ]

Thu, 28 August 2008 18:49

brooksaix
Messages: 3
Registered: February 2008

Junior Member

If you are going to partition on the InnoDB primary key (the clustered index) you won't get any performance benefits and will slow down access by other columns.

However, you can get operational benefits, like faster optimization of tables if you only need to optimize the most recent partitions (assuming you partition by date or a sequentially assigned key).

Report message to a moderator

Previous Topic:	Storage engine for a datmart
Next Topic:	creating index is not always good

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 22:12:02 EDT 2009

Total time taken to generate the page: 0.03917 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.