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