版本：3.0.1 linux：centos7
*************************** 1. row ***************************
Table: daily_user_action_2019-09-15
Create Table: CREATE TABLE daily_user_action_2019-09-15 (
id varchar(32) NOT NULL COMMENT ‘主键’,
uid_crc32 bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘Uid crc32值’,
uid varchar(100) NOT NULL COMMENT ‘用户标识uid’,
version varchar(20) NOT NULL COMMENT ‘使用版本’,
channel varchar(50) NOT NULL COMMENT ‘历史渠道、归因渠道’,
package_channel varchar(50) NOT NULL COMMENT ‘包内渠道’,
action_id varchar(200) NOT NULL COMMENT ‘事件ID、事件标识’,
count int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘事件触发次数’,
act_date varchar(10) NOT NULL COMMENT ‘事件触发日期’,
act_time varchar(8) NOT NULL COMMENT ‘事件触发时间’,
PRIMARY KEY (id,uid_crc32)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
PARTITION BY HASH( uid_crc32 )
PARTITIONS 100
select * from daily_user_action_2019-09-15 limit 1000;
直接卡死了，limit20不会卡住