MySQL Workbench Manual  /  ...  /  The Partitioning Tab

8.1.11.6 The Partitioning Tab

To enable partitioning for your table, check the Enable Partitioning check box. This enables the partitioning options.

Figure 8.22 The Partitioning Tab

The figure content is described in the surrounding text.

The Partition By pop-up menu displays the types of partitions you can create:

  • HASH

  • LINEAR HASH

  • KEY

  • LINEAR KEY

  • RANGE

  • LIST

Use the Parameters field to define any parameters to be supplied to the partitioning function, such as an integer column value.

Choose the number of partitions from the Partition Count list. To manually configure your partitions, check the Manual check box. This enables entry of values into the partition configuration table. The entries in this table are:

  • Partition

  • Values

  • Data Directory

  • Index Directory

  • Min Rows

  • Max Rows

  • Comment

Subpartitioning is also available. For more information about partitioning, see Partitioning.


User Comments
Sign Up Login You must be logged in to post a comment.