基础知识参考:
http://dev.mysql.com/doc/refman/5.1/zh/partitioning.html#partitioning-range
其它注意力事项:
一、Mysql里面数据库不方便面像SQL Server那样指定存储文件(可以实现,但不方便);
二、Mysql中表分区中,分区函数中指定的列名,必需是PRIMARY KEY列(这个很不爽);
三、创建的例子
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees` (
`id` int(11) NOT NULL,
`store_id` int(11) NOT NULL,
PRIMARY KEY (`Id`,`store_id`),
KEY `PK_employees_id` (`Id`),
Key `PK_employees_store_id` (`store_id`),
) ENGINE=InnoDB DEFAULT CHARSET=gbk
PARTITION BY RANGE (store_id)
(PARTITION p0 VALUES LESS THAN (6) ENGINE = InnoDB,
PARTITION p1 VALUES LESS THAN (11) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (16) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (21) ENGINE = InnoDB)