表结构
CREATE TABLE `tbldatasopcal_1000r_100c` (
`lesson_id` bigint(20) NOT NULL,
`assistant_uid` bigint(20) NOT NULL,
`save_time` bigint(20) NOT NULL,
`user_type` varchar(100) NOT NULL,
`transfer_status` bigint(20) NOT NULL,
`course_id` bigint(20) DEFAULT NULL,
`update_time` bigint(20) DEFAULT NULL,
`group_level_1` bigint(20) DEFAULT NULL,
`group_level_2` bigint(20) DEFAULT NULL,
`group_level_3` bigint(20) DEFAULT NULL,
`group_level_4` bigint(20) DEFAULT NULL,
`group_level_5` bigint(20) DEFAULT NULL,
`group_level_6` bigint(20) DEFAULT NULL,
`group_level_7` bigint(20) DEFAULT NULL,
`group_level_8` bigint(20) DEFAULT NULL,
`index1` bigint(20) DEFAULT NULL,
`index2` bigint(20) DEFAULT NULL,
`index3` bigint(20) DEFAULT NULL,
`index4` bigint(20) DEFAULT NULL,
`index5` bigint(20) DEFAULT NULL,
`index6` bigint(20) DEFAULT NULL,
`index7` bigint(20) DEFAULT NULL,
`index8` bigint(20) DEFAULT NULL,
`index9` bigint(20) DEFAULT NULL,
`index10` bigint(20) DEFAULT NULL,
`col_1` bigint(20) DEFAULT NULL,
`col_2` bigint(20) DEFAULT NULL,
`col_3` bigint(20) DEFAULT NULL,
`col_4` bigint(20) DEFAULT NULL,
`col_5` bigint(20) DEFAULT NULL,
`col_6` bigint(20) DEFAULT NULL,
`col_7` bigint(20) DEFAULT NULL,
`col_8` bigint(20) DEFAULT NULL,
`col_9` bigint(20) DEFAULT NULL,
`col_10` bigint(20) DEFAULT NULL,
`col_11` bigint(20) DEFAULT NULL,
`col_12` bigint(20) DEFAULT NULL,
`col_13` bigint(20) DEFAULT NULL,
`col_14` bigint(20) DEFAULT NULL,
`col_15` bigint(20) DEFAULT NULL,
`col_16` bigint(20) DEFAULT NULL,
`col_17` bigint(20) DEFAULT NULL,
`col_18` bigint(20) DEFAULT NULL,
`col_19` bigint(20) DEFAULT NULL,
`col_20` bigint(20) DEFAULT NULL,
`col_21` bigint(20) DEFAULT NULL,
`col_22` bigint(20) DEFAULT NULL,
`col_23` bigint(20) DEFAULT NULL,
`col_24` bigint(20) DEFAULT NULL,
`col_25` bigint(20) DEFAULT NULL,
`col_26` bigint(20) DEFAULT NULL,
`col_27` bigint(20) DEFAULT NULL,
`col_28` bigint(20) DEFAULT NULL,
`col_29` bigint(20) DEFAULT NULL,
`col_30` bigint(20) DEFAULT NULL,
`col_31` bigint(20) DEFAULT NULL,
`col_32` bigint(20) DEFAULT NULL,
`col_33` bigint(20) DEFAULT NULL,
`col_34` bigint(20) DEFAULT NULL,
`col_35` bigint(20) DEFAULT NULL,
`col_36` bigint(20) DEFAULT NULL,
`col_37` bigint(20) DEFAULT NULL,
`col_38` bigint(20) DEFAULT NULL,
`col_39` bigint(20) DEFAULT NULL,
`col_40` bigint(20) DEFAULT NULL,
`col_41` bigint(20) DEFAULT NULL,
`col_42` bigint(20) DEFAULT NULL,
`col_43` bigint(20) DEFAULT NULL,
`col_44` bigint(20) DEFAULT NULL,
`col_45` bigint(20) DEFAULT NULL,
`col_46` bigint(20) DEFAULT NULL,
`col_47` bigint(20) DEFAULT NULL,
`col_48` bigint(20) DEFAULT NULL,
`col_49` bigint(20) DEFAULT NULL,
`col_50` bigint(20) DEFAULT NULL,
`col_51` bigint(20) DEFAULT NULL,
`col_52` bigint(20) DEFAULT NULL,
`col_53` bigint(20) DEFAULT NULL,
`col_54` bigint(20) DEFAULT NULL,
`col_55` bigint(20) DEFAULT NULL,
`col_56` bigint(20) DEFAULT NULL,
`col_57` bigint(20) DEFAULT NULL,
`col_58` bigint(20) DEFAULT NULL,
`col_59` bigint(20) DEFAULT NULL,
`col_60` bigint(20) DEFAULT NULL,
`col_61` bigint(20) DEFAULT NULL,
`col_62` bigint(20) DEFAULT NULL,
`col_63` bigint(20) DEFAULT NULL,
`col_64` bigint(20) DEFAULT NULL,
`col_65` bigint(20) DEFAULT NULL,
`col_66` bigint(20) DEFAULT NULL,
`col_67` bigint(20) DEFAULT NULL,
`col_68` bigint(20) DEFAULT NULL,
`col_69` bigint(20) DEFAULT NULL,
`col_70` bigint(20) DEFAULT NULL,
`col_71` bigint(20) DEFAULT NULL,
`col_72` bigint(20) DEFAULT NULL,
`col_73` bigint(20) DEFAULT NULL,
`col_74` bigint(20) DEFAULT NULL,
`col_75` bigint(20) DEFAULT NULL,
PRIMARY KEY (`lesson_id`,`assistant_uid`,`transfer_status`,`user_type`,`save_time`) /*T![clustered_index] NONCLUSTERED */,
KEY `course_id_idx` (`course_id`),
KEY `update_time_idx` (`update_time`),
KEY `group_level_1_idx` (`group_level_1`),
KEY `group_level_2_idx` (`group_level_2`),
KEY `group_level_3_idx` (`group_level_3`),
KEY `group_level_4_idx` (`group_level_4`),
KEY `group_level_5_idx` (`group_level_5`),
KEY `group_level_6_idx` (`group_level_6`),
KEY `group_level_7_idx` (`group_level_7`),
KEY `group_level_8_idx` (`group_level_8`),
KEY `index1_idx` (`index1`),
KEY `index2_idx` (`index2`),
KEY `index3_idx` (`index3`),
KEY `index4_idx` (`index4`),
KEY `index5_idx` (`index5`),
KEY `index6_idx` (`index6`),
KEY `index7_idx` (`index7`),
KEY `index8_idx` (`index8`),
KEY `index9_idx` (`index9`),
KEY `index10_idx` (`index10`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
样例sql
select lesson_id,group_level_8,sum(col_1),sum(col_2),sum(col_3),sum(col_4),sum(col_5),sum(col_6),sum(col_7),sum(col_8),sum(col_9),sum(col_10),sum(col_11),sum(col_12),sum(col_13),sum(col_14),sum(col_15),sum(col_16),sum(col_17),sum(col_18),sum(col_19),sum(col_20),sum(col_21),sum(col_22),sum(col_23),sum(col_24),sum(col_25),sum(col_26),sum(col_27),sum(col_28),sum(col_29),sum(col_30),sum(col_31),sum(col_32),sum(col_33),sum(col_34),sum(col_35),sum(col_36),sum(col_37),sum(col_38),sum(col_39),sum(col_40) from tbldatasopcal_1000r_100c where index1 in (1,2,3) and index2 in (1,2,3) and index4 in (1,2,3) and index5 in (1,2,3) group by lesson_id,group_level_8 limit 1\G
我把mpp 关了也不行
