GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Innodb and Partitioning

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Innodb and Partitioning

    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?

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

    Comment


    • #3
      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).

      Comment

      Working...
      X