Mysql表分区

 

查看Mysql表分区语句

SELECT

  partition_name part, 

  partition_expression expr, 

  partition_description descr, 

  table_rows 

FROM

  INFORMATION_SCHEMA.partitions 

WHERE

  TABLE_SCHEMA = schema() 

  AND TABLE_NAME='table'; 

KEY表分区

ALTER TABLE users PARTITION by key('')
partitions 10;

RANGE 表分区

ALTER TABLE tbl_rtdata PARTITION BY RANGE (Month(fld_date))
( 
PARTITION p_Apr VALUES LESS THAN (TO_DAYS('2012-05-01')),
PARTITION p_May VALUES LESS THAN (TO_DAYS('2012-06-01')), 
PARTITION p_Dec VALUES LESS THAN MAXVALUE );

移除表的分区

ALTER TABLE tablename
REMOVE PARTITIONING ;
使用remove移除分区是仅仅移除分区的定义，并不会删除数据。