mysql-优化完美版教学说明.pptVIP

表选项： Partition by 类型 (分区依据） 类型：hash, key,range,list Hash (值表达式） partitions N; Key (字段） partitions N; Range(字段值表达式） （ partition p_name VALUES LESS THAN (值）， partition p_name VALUES LESS THAN MAXVALUE ） list(字段值表达式） （ partition p_name VALUES IN (值列表）， partition p_name VALUES IN （值列表） ） 注意，分组字段必须要是主键中的字段。 删除分区： 管理分区： Range，list ALTER TABLE ADD PARTITION (PARTITION p3 VALUES LESS THAN (2000)); Alter table table_name drop partition p3。 Hash，key ALTER TABLE clients ADD PARTITION PARTITIONS N ALTER TABLE clients COALESCE PARTITION N 详细语法： partition_options: PARTITION BY [LINEAR] HASH(expr) | [LINEAR] KEY(column_list) | RANGE(expr) | LIST(column_list) [PARTITIONS num] [ SUBPARTITION BY [LINEAR] HASH(expr) | [LINEAR] KEY(column_list) [SUBPARTITIONS(num)] ] [(partition_definition), [(partition_definition)], ...] partition_definition: PARTITION partition_name [VALUES { LESS THAN (expr) | MAXVALUE | IN (value_list) }] [[STORAGE] ENGINE [=] engine-name] [COMMENT [=] comment_text ] [DATA DIRECTORY [=] data_dir] [INDEX DIRECTORY [=] index_dir] [MAX_ROWS [=] max_number_of_rows] [MIN_ROWS [=] min_number_of_rows] [TABLESPACE [=] (tablespace_name)] [NODEGROUP [=] node_group_id] [(subpartition_definition), [(subpartition_definition)], ...] subpartition_definition: SUBPARTITION logical_name [[STORAGE] ENGINE [=] engine-name] [COMMENT [=] comment_text ] [DATA DIRECTORY [=] data_dir] [INDEX DIRECTORY [=] index_dir] [MAX_ROWS [=] max_number_of_rows] [MIN_ROWS [=] min_number_of_rows] [TABLESPACE [=] (tablespace_name)] [NODEGROUP [=] node_group_id] * 测试语句： CREATE TABLE IF NOT EXISTS `article1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `pubdate` int(11) NOT NULL,