 |
Partition editing is part of partition management | |
|
|---|
 |
Module for editing partitions of a MySQL table:
|
| The type of partitioning can be changed:
| Partitioning by: | Choice of partitioning method. |
| Expression: | Expression or table field by which to partition. |
| Number of partitions: | Number of partitions can be changed. |
| Start: | Start the partition editor with the set parameters. |
|
|
| Editing the partitions: |
| Name: | Name of the partition. |
| Data Directory: | Number of data rows in partition. |
| Minimum number of lines: | MySQL partition management benchmark that specifies the minimum number of data rows in the partition.
| | Maximum number of lines: | MySQL partition management benchmark that specifies the maximum number of data rows in the partition.
| | TABLESPACE: | Selection of a defined TABLESPACE entry that contains information about the storage space of tables.
| | Comment: | Comment on the partition. |
|
For Data directory, Minimum number of lines, Maximum number of lines and TABLESPACE, the value contained can be copied to all other partitions by double-clicking on the input field.
|
|
 |
Save the changes to the partitions. |
 |
Show SQL statement of changes. |
|
| Example of editing sub-partitions: |
 |
Example with partitioning using RANGE and HASH for sub-partitions:
|
For more information see: RANGE partitioning
|
|
