业务需要mysql按照key分区,方法如下: alter table dbname.tablename partition by key(keyname) partitions partions_num;