Databases Reference
In-Depth Information
Here, we enter a
PARTITION BY RANGE
clause, which will create partitions on the
id
column:
PARTITION BY RANGE (id) (
PARTITION p0 VALUES LESS THAN (1000),
PARTITION p1 VALUES LESS THAN (2000),
PARTITION p2 VALUES LESS THAN (30000)
);
Maintaining partitions
For a table on which a partition has been defined, the
Operations
page displays a
Partition maintenance
dialog where we can:
• Choose a partition and then request an action, such as
Rebuild
• Remove the partitioning
Exporting a partition definition
Finally, exporting this
test
table in SQL mode produces statements with embedded
comments that a MySQL 5.1 server would recognize and interpret in order to
recreate the same partitions:
CREATE TABLE `test` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (id)
(PARTITION p0 VALUES LESS THAN (1000) ENGINE = MyISAM,
PARTITION p1 VALUES LESS THAN (2000) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (3000) ENGINE = MyISAM) */;
Search WWH ::
Custom Search