mysql分区partition
创建实例: CREATE TABLE HASH_EMP ( tid int, tname char(255) ) PARTITION BY HASH (tid) PARTITIONS 8;
查看:
select partition_name,partition_expression,partition_description,table_rows from information_schema.partitions where table_schema = schema() and table_name = 'ib_origin';
https://www.cnblogs.com/shibazi/p/3832852.html
另外有几个结论:
空间差不多
无索引,分区>>不分区
有索引,分区>不分区