8.0.25 mysqldump因分区过多导致导出数据缓慢

问题描述

8.0.25 mysqldump导出数据迟迟不结束

环境信息

1. mysqldump阻塞状态

2. mysqldump的general log

3.执行缓慢SQL

mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
Query OK, 0 rows affected (0.00 sec)

mysql>
SELECT LOGFILE_GROUP_NAME,
FILE_NAME,
TOTAL_EXTENTS,
INITIAL_SIZE,
ENGINE,
EXTRA
FROM INFORMATION_SCHEMA.FILES
WHERE FILE_TYPE = 'UNDO LOG'
AND FILE_NAME IS NOT NULL
AND LOGFILE_GROUP_NAME IS NOT NULL
AND LOGFILE_GROUP_NAME IN
(SELECT DISTINCT LOGFILE_GROUP_NAME
FROM INFORMATION_SCHEMA.FILES
WHERE FILE_TYPE = 'DATAFILE'
AND TABLESPACE_NAME IN
(SELECT DISTINCT TABLESPACE_NAME
FROM INFORMATION_SCHEMA.PARTITIONS
WHERE TABLE_SCHEMA IN ('cbps_pay_rz_02_01_b')))
GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE, TOTAL_EXTENTS, INITIAL_SIZE
ORDER BY LOGFILE_GROUP_NAME;

4. 执行计划

从执行计划可以看到 parent_partition_id 字段未走索引导致mysqldump执行缓慢

--mysqldump执行缓慢执行计划，分区多

--自己测试环境mysqldump执行缓慢执行计划，分区少

5. mysql数据库分区数量

问题总结

MySQL实例分区数为8W+时，由于分区数过多，导致mysqldump中涉及INFORMATION_SCHEMA.PARTITIONS的元数据的查询语句执行效率急剧下降，该语句耗时近2h，会造成mysqldump迟迟不能结束的现象。

优化建议

降低MySQL实例分区数，当MySQL实例分区数为2.7w时，mysqldump中涉及INFORMATION_SCHEMA.PARTITIONS的元数据查询耗时为17.47秒

问题复现

CREATE TABLE `cbps_buffmsg` (
`PARTID` smallint NOT NULL ,
`MSGSEQ` int NOT NULL ,
`IP` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL ,
`RSFLAG` smallint DEFAULT NULL,
`LIMITID` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL ,
`MSGTYPE` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`BANKCODE` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`RCVSYSDATE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '1900-01-01' ,
`RCVSYSTIME` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '00:00:00',
`STATUS` smallint DEFAULT NULL,
`DSRTIMES` smallint DEFAULT NULL,
`MSGCONTENT` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ,
`MAPCONTENT` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ,
`ROUTEINFO` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL ,
`ERRCODE` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL ,
PRIMARY KEY (`PARTID`,`MSGSEQ`),
KEY `CBPS_BUFFMSG_INDEX` (`PARTID`,`LIMITID`,`STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='限流缓存表'
/*!50100 PARTITION BY LIST (`PARTID`)
(PARTITION P1 VALUES IN (1) ENGINE = InnoDB,
PARTITION P2 VALUES IN (2) ENGINE = InnoDB,
PARTITION P3 VALUES IN (3) ENGINE = InnoDB,
PARTITION P4 VALUES IN (4) ENGINE = InnoDB,
PARTITION P5 VALUES IN (5) ENGINE = InnoDB,
PARTITION P6 VALUES IN (6) ENGINE = InnoDB,
PARTITION P7 VALUES IN (7) ENGINE = InnoDB,
PARTITION P8 VALUES IN (8) ENGINE = InnoDB,
PARTITION P9 VALUES IN (9) ENGINE = InnoDB,
PARTITION P10 VALUES IN (10) ENGINE = InnoDB,
PARTITION P11 VALUES IN (11) ENGINE = InnoDB,
PARTITION P12 VALUES IN (12) ENGINE = InnoDB,
PARTITION P13 VALUES IN (13) ENGINE = InnoDB,
PARTITION P14 VALUES IN (14) ENGINE = InnoDB,
PARTITION P15 VALUES IN (15) ENGINE = InnoDB,
PARTITION P16 VALUES IN (16) ENGINE = InnoDB,
PARTITION P17 VALUES IN (17) ENGINE = InnoDB,
PARTITION P18 VALUES IN (18) ENGINE = InnoDB,
PARTITION P19 VALUES IN (19) ENGINE = InnoDB,
PARTITION P20 VALUES IN (20) ENGINE = InnoDB,
PARTITION P21 VALUES IN (21) ENGINE = InnoDB,
PARTITION P22 VALUES IN (22) ENGINE = InnoDB,
PARTITION P23 VALUES IN (23) ENGINE = InnoDB,
PARTITION P24 VALUES IN (24) ENGINE = InnoDB,
PARTITION P25 VALUES IN (25) ENGINE = InnoDB,
PARTITION P26 VALUES IN (26) ENGINE = InnoDB,
PARTITION P27 VALUES IN (27) ENGINE = InnoDB,
PARTITION P28 VALUES IN (28) ENGINE = InnoDB,
PARTITION P29 VALUES IN (29) ENGINE = InnoDB,
PARTITION P30 VALUES IN (30) ENGINE = InnoDB,
PARTITION P31 VALUES IN (31) ENGINE = InnoDB,
PARTITION P32 VALUES IN (32) ENGINE = InnoDB,
PARTITION P33 VALUES IN (33) ENGINE = InnoDB,
PARTITION P34 VALUES IN (34) ENGINE = InnoDB,
PARTITION P35 VALUES IN (35) ENGINE = InnoDB,
PARTITION P36 VALUES IN (36) ENGINE = InnoDB,
PARTITION P37 VALUES IN (37) ENGINE = InnoDB,
PARTITION P38 VALUES IN (38) ENGINE = InnoDB,
PARTITION P39 VALUES IN (39) ENGINE = InnoDB,
PARTITION P40 VALUES IN (40) ENGINE = InnoDB,
PARTITION P41 VALUES IN (41) ENGINE = InnoDB,
PARTITION P42 VALUES IN (42) ENGINE = InnoDB,
PARTITION P43 VALUES IN (43) ENGINE = InnoDB,
PARTITION P44 VALUES IN (44) ENGINE = InnoDB,
PARTITION P45 VALUES IN (45) ENGINE = InnoDB,
PARTITION P46 VALUES IN (46) ENGINE = InnoDB,
PARTITION P47 VALUES IN (47) ENGINE = InnoDB,
PARTITION P48 VALUES IN (48) ENGINE = InnoDB,
PARTITION P49 VALUES IN (49) ENGINE = InnoDB,
PARTITION P50 VALUES IN (50) ENGINE = InnoDB,
PARTITION P51 VALUES IN (51) ENGINE = InnoDB,
PARTITION P52 VALUES IN (52) ENGINE = InnoDB,
PARTITION P53 VALUES IN (53) ENGINE = InnoDB,
PARTITION P54 VALUES IN (54) ENGINE = InnoDB,
PARTITION P55 VALUES IN (55) ENGINE = InnoDB,
PARTITION P56 VALUES IN (56) ENGINE = InnoDB,
PARTITION P57 VALUES IN (57) ENGINE = InnoDB,
PARTITION P58 VALUES IN (58) ENGINE = InnoDB,
PARTITION P59 VALUES IN (59) ENGINE = InnoDB,
PARTITION P60 VALUES IN (60) ENGINE = InnoDB,
PARTITION P61 VALUES IN (61) ENGINE = InnoDB,
PARTITION P62 VALUES IN (62) ENGINE = InnoDB,
PARTITION P63 VALUES IN (63) ENGINE = InnoDB,
PARTITION P64 VALUES IN (64) ENGINE = InnoDB,
PARTITION P65 VALUES IN (65) ENGINE = InnoDB,
PARTITION P66 VALUES IN (66) ENGINE = InnoDB,
PARTITION P67 VALUES IN (67) ENGINE = InnoDB,
PARTITION P68 VALUES IN (68) ENGINE = InnoDB,
PARTITION P69 VALUES IN (69) ENGINE = InnoDB,
PARTITION P70 VALUES IN (70) ENGINE = InnoDB,
PARTITION P71 VALUES IN (71) ENGINE = InnoDB,
PARTITION P72 VALUES IN (72) ENGINE = InnoDB,
PARTITION P73 VALUES IN (73) ENGINE = InnoDB,
PARTITION P74 VALUES IN (74) ENGINE = InnoDB,
PARTITION P75 VALUES IN (75) ENGINE = InnoDB,
PARTITION P76 VALUES IN (76) ENGINE = InnoDB,
PARTITION P77 VALUES IN (77) ENGINE = InnoDB,
PARTITION P78 VALUES IN (78) ENGINE = InnoDB,
PARTITION P79 VALUES IN (79) ENGINE = InnoDB,
PARTITION P80 VALUES IN (80) ENGINE = InnoDB,
PARTITION P81 VALUES IN (81) ENGINE = InnoDB,
PARTITION P82 VALUES IN (82) ENGINE = InnoDB,
PARTITION P83 VALUES IN (83) ENGINE = InnoDB,
PARTITION P84 VALUES IN (84) ENGINE = InnoDB,
PARTITION P85 VALUES IN (85) ENGINE = InnoDB,
PARTITION P86 VALUES IN (86) ENGINE = InnoDB,
PARTITION P87 VALUES IN (87) ENGINE = InnoDB,
PARTITION P88 VALUES IN (88) ENGINE = InnoDB,
PARTITION P89 VALUES IN (89) ENGINE = InnoDB,
PARTITION P90 VALUES IN (90) ENGINE = InnoDB,
PARTITION P91 VALUES IN (91) ENGINE = InnoDB,
PARTITION P92 VALUES IN (92) ENGINE = InnoDB,
PARTITION P93 VALUES IN (93) ENGINE = InnoDB,
PARTITION P94 VALUES IN (94) ENGINE = InnoDB,
PARTITION P95 VALUES IN (95) ENGINE = InnoDB,
PARTITION P96 VALUES IN (96) ENGINE = InnoDB,
PARTITION P97 VALUES IN (97) ENGINE = InnoDB,
PARTITION P98 VALUES IN (98) ENGINE = InnoDB,
PARTITION P99 VALUES IN (99) ENGINE = InnoDB,
PARTITION P100 VALUES IN (100) ENGINE = InnoDB,
PARTITION P101 VALUES IN (101) ENGINE = InnoDB,
PARTITION P102 VALUES IN (102) ENGINE = InnoDB,
PARTITION P103 VALUES IN (103) ENGINE = InnoDB,
PARTITION P104 VALUES IN (104) ENGINE = InnoDB,
PARTITION P105 VALUES IN (105) ENGINE = InnoDB,
PARTITION P106 VALUES IN (106) ENGINE = InnoDB,
PARTITION P107 VALUES IN (107) ENGINE = InnoDB,
PARTITION P108 VALUES IN (108) ENGINE = InnoDB,
PARTITION P109 VALUES IN (109) ENGINE = InnoDB,
PARTITION P110 VALUES IN (110) ENGINE = InnoDB,
PARTITION P111 VALUES IN (111) ENGINE = InnoDB,
PARTITION P112 VALUES IN (112) ENGINE = InnoDB,
PARTITION P113 VALUES IN (113) ENGINE = InnoDB,
PARTITION P114 VALUES IN (114) ENGINE = InnoDB,
PARTITION P115 VALUES IN (115) ENGINE = InnoDB,
PARTITION P116 VALUES IN (116) ENGINE = InnoDB,
PARTITION P117 VALUES IN (117) ENGINE = InnoDB,
PARTITION P118 VALUES IN (118) ENGINE = InnoDB,
PARTITION P119 VALUES IN (119) ENGINE = InnoDB,
PARTITION P120 VALUES IN (120) ENGINE = InnoDB,
PARTITION P121 VALUES IN (121) ENGINE = InnoDB,
PARTITION P122 VALUES IN (122) ENGINE = InnoDB,
PARTITION P123 VALUES IN (123) ENGINE = InnoDB,
PARTITION P124 VALUES IN (124) ENGINE = InnoDB,
PARTITION P125 VALUES IN (125) ENGINE = InnoDB,
PARTITION P126 VALUES IN (126) ENGINE = InnoDB,
PARTITION P127 VALUES IN (127) ENGINE = InnoDB,
PARTITION P128 VALUES IN (128) ENGINE = InnoDB,
PARTITION P129 VALUES IN (129) ENGINE = InnoDB,
PARTITION P130 VALUES IN (130) ENGINE = InnoDB,
PARTITION P131 VALUES IN (131) ENGINE = InnoDB,
PARTITION P132 VALUES IN (132) ENGINE = InnoDB,
PARTITION P133 VALUES IN (133) ENGINE = InnoDB,
PARTITION P134 VALUES IN (134) ENGINE = InnoDB,
PARTITION P135 VALUES IN (135) ENGINE = InnoDB,
PARTITION P136 VALUES IN (136) ENGINE = InnoDB,
PARTITION P137 VALUES IN (137) ENGINE = InnoDB,
PARTITION P138 VALUES IN (138) ENGINE = InnoDB,
PARTITION P139 VALUES IN (139) ENGINE = InnoDB,
PARTITION P140 VALUES IN (140) ENGINE = InnoDB,
PARTITION P141 VALUES IN (141) ENGINE = InnoDB,
PARTITION P142 VALUES IN (142) ENGINE = InnoDB,
PARTITION P143 VALUES IN (143) ENGINE = InnoDB,
PARTITION P144 VALUES IN (144) ENGINE = InnoDB,
PARTITION P145 VALUES IN (145) ENGINE = InnoDB,
PARTITION P146 VALUES IN (146) ENGINE = InnoDB,
PARTITION P147 VALUES IN (147) ENGINE = InnoDB,
PARTITION P148 VALUES IN (148) ENGINE = InnoDB,
PARTITION P149 VALUES IN (149) ENGINE = InnoDB,
PARTITION P150 VALUES IN (150) ENGINE = InnoDB,
PARTITION P151 VALUES IN (151) ENGINE = InnoDB,
PARTITION P152 VALUES IN (152) ENGINE = InnoDB,
PARTITION P153 VALUES IN (153) ENGINE = InnoDB,
PARTITION P154 VALUES IN (154) ENGINE = InnoDB,
PARTITION P155 VALUES IN (155) ENGINE = InnoDB,
PARTITION P156 VALUES IN (156) ENGINE = InnoDB,
PARTITION P157 VALUES IN (157) ENGINE = InnoDB,
PARTITION P158 VALUES IN (158) ENGINE = InnoDB,
PARTITION P159 VALUES IN (159) ENGINE = InnoDB,
PARTITION P160 VALUES IN (160) ENGINE = InnoDB,
PARTITION P161 VALUES IN (161) ENGINE = InnoDB,
PARTITION P162 VALUES IN (162) ENGINE = InnoDB,
PARTITION P163 VALUES IN (163) ENGINE = InnoDB,
PARTITION P164 VALUES IN (164) ENGINE = InnoDB,
PARTITION P165 VALUES IN (165) ENGINE = InnoDB,
PARTITION P166 VALUES IN (166) ENGINE = InnoDB,
PARTITION P167 VALUES IN (167) ENGINE = InnoDB,
PARTITION P168 VALUES IN (168) ENGINE = InnoDB,
PARTITION P169 VALUES IN (169) ENGINE = InnoDB,
PARTITION P170 VALUES IN (170) ENGINE = InnoDB,
PARTITION P171 VALUES IN (171) ENGINE = InnoDB,
PARTITION P172 VALUES IN (172) ENGINE = InnoDB,
PARTITION P173 VALUES IN (173) ENGINE = InnoDB,
PARTITION P174 VALUES IN (174) ENGINE = InnoDB,
PARTITION P175 VALUES IN (175) ENGINE = InnoDB,
PARTITION P176 VALUES IN (176) ENGINE = InnoDB,
PARTITION P177 VALUES IN (177) ENGINE = InnoDB,
PARTITION P178 VALUES IN (178) ENGINE = InnoDB,
PARTITION P179 VALUES IN (179) ENGINE = InnoDB,
PARTITION P180 VALUES IN (180) ENGINE = InnoDB,
PARTITION P181 VALUES IN (181) ENGINE = InnoDB,
PARTITION P182 VALUES IN (182) ENGINE = InnoDB,
PARTITION P183 VALUES IN (183) ENGINE = InnoDB,
PARTITION P184 VALUES IN (184) ENGINE = InnoDB,
PARTITION P185 VALUES IN (185) ENGINE = InnoDB,
PARTITION P186 VALUES IN (186) ENGINE = InnoDB,
PARTITION P187 VALUES IN (187) ENGINE = InnoDB,
PARTITION P188 VALUES IN (188) ENGINE = InnoDB,
PARTITION P189 VALUES IN (189) ENGINE = InnoDB,
PARTITION P190 VALUES IN (190) ENGINE = InnoDB,
PARTITION P191 VALUES IN (191) ENGINE = InnoDB,
PARTITION P192 VALUES IN (192) ENGINE = InnoDB,
PARTITION P193 VALUES IN (193) ENGINE = InnoDB,
PARTITION P194 VALUES IN (194) ENGINE = InnoDB,
PARTITION P195 VALUES IN (195) ENGINE = InnoDB,
PARTITION P196 VALUES IN (196) ENGINE = InnoDB,
PARTITION P197 VALUES IN (197) ENGINE = InnoDB,
PARTITION P198 VALUES IN (198) ENGINE = InnoDB,
PARTITION P199 VALUES IN (199) ENGINE = InnoDB,
PARTITION P200 VALUES IN (200) ENGINE = InnoDB,
PARTITION P201 VALUES IN (201) ENGINE = InnoDB,
PARTITION P202 VALUES IN (202) ENGINE = InnoDB,
PARTITION P203 VALUES IN (203) ENGINE = InnoDB,
PARTITION P204 VALUES IN (204) ENGINE = InnoDB,
PARTITION P205 VALUES IN (205) ENGINE = InnoDB,
PARTITION P206 VALUES IN (206) ENGINE = InnoDB,
PARTITION P207 VALUES IN (207) ENGINE = InnoDB,
PARTITION P208 VALUES IN (208) ENGINE = InnoDB,
PARTITION P209 VALUES IN (209) ENGINE = InnoDB,
PARTITION P210 VALUES IN (210) ENGINE = InnoDB,
PARTITION P211 VALUES IN (211) ENGINE = InnoDB,
PARTITION P212 VALUES IN (212) ENGINE = InnoDB,
PARTITION P213 VALUES IN (213) ENGINE = InnoDB,
PARTITION P214 VALUES IN (214) ENGINE = InnoDB,
PARTITION P215 VALUES IN (215) ENGINE = InnoDB,
PARTITION P216 VALUES IN (216) ENGINE = InnoDB,
PARTITION P217 VALUES IN (217) ENGINE = InnoDB,
PARTITION P218 VALUES IN (218) ENGINE = InnoDB,
PARTITION P219 VALUES IN (219) ENGINE = InnoDB,
PARTITION P220 VALUES IN (220) ENGINE = InnoDB,
PARTITION P221 VALUES IN (221) ENGINE = InnoDB,
PARTITION P222 VALUES IN (222) ENGINE = InnoDB,
PARTITION P223 VALUES IN (223) ENGINE = InnoDB,
PARTITION P224 VALUES IN (224) ENGINE = InnoDB,
PARTITION P225 VALUES IN (225) ENGINE = InnoDB,
PARTITION P226 VALUES IN (226) ENGINE = InnoDB,
PARTITION P227 VALUES IN (227) ENGINE = InnoDB,
PARTITION P228 VALUES IN (228) ENGINE = InnoDB,
PARTITION P229 VALUES IN (229) ENGINE = InnoDB,
PARTITION P230 VALUES IN (230) ENGINE = InnoDB,
PARTITION P231 VALUES IN (231) ENGINE = InnoDB,
PARTITION P232 VALUES IN (232) ENGINE = InnoDB,
PARTITION P233 VALUES IN (233) ENGINE = InnoDB,
PARTITION P234 VALUES IN (234) ENGINE = InnoDB,
PARTITION P235 VALUES IN (235) ENGINE = InnoDB,
PARTITION P236 VALUES IN (236) ENGINE = InnoDB,
PARTITION P237 VALUES IN (237) ENGINE = InnoDB,
PARTITION P238 VALUES IN (238) ENGINE = InnoDB,
PARTITION P239 VALUES IN (239) ENGINE = InnoDB,
PARTITION P240 VALUES IN (240) ENGINE = InnoDB,
PARTITION P241 VALUES IN (241) ENGINE = InnoDB,
PARTITION P242 VALUES IN (242) ENGINE = InnoDB,
PARTITION P243 VALUES IN (243) ENGINE = InnoDB,
PARTITION P244 VALUES IN (244) ENGINE = InnoDB,
PARTITION P245 VALUES IN (245) ENGINE = InnoDB,
PARTITION P246 VALUES IN (246) ENGINE = InnoDB,
PARTITION P247 VALUES IN (247) ENGINE = InnoDB,
PARTITION P248 VALUES IN (248) ENGINE = InnoDB,
PARTITION P249 VALUES IN (249) ENGINE = InnoDB,
PARTITION P250 VALUES IN (250) ENGINE = InnoDB,
PARTITION P251 VALUES IN (251) ENGINE = InnoDB,
PARTITION P252 VALUES IN (252) ENGINE = InnoDB,
PARTITION P253 VALUES IN (253) ENGINE = InnoDB,
PARTITION P254 VALUES IN (254) ENGINE = InnoDB,
PARTITION P255 VALUES IN (255) ENGINE = InnoDB,
PARTITION P256 VALUES IN (256) ENGINE = InnoDB,
PARTITION P257 VALUES IN (257) ENGINE = InnoDB,
PARTITION P258 VALUES IN (258) ENGINE = InnoDB,
PARTITION P259 VALUES IN (259) ENGINE = InnoDB,
PARTITION P260 VALUES IN (260) ENGINE = InnoDB,
PARTITION P261 VALUES IN (261) ENGINE = InnoDB,
PARTITION P262 VALUES IN (262) ENGINE = InnoDB,
PARTITION P263 VALUES IN (263) ENGINE = InnoDB,
PARTITION P264 VALUES IN (264) ENGINE = InnoDB,
PARTITION P265 VALUES IN (265) ENGINE = InnoDB,
PARTITION P266 VALUES IN (266) ENGINE = InnoDB,
PARTITION P267 VALUES IN (267) ENGINE = InnoDB,
PARTITION P268 VALUES IN (268) ENGINE = InnoDB,
PARTITION P269 VALUES IN (269) ENGINE = InnoDB,
PARTITION P270 VALUES IN (270) ENGINE = InnoDB,
PARTITION P271 VALUES IN (271) ENGINE = InnoDB,
PARTITION P272 VALUES IN (272) ENGINE = InnoDB,
PARTITION P273 VALUES IN (273) ENGINE = InnoDB,
PARTITION P274 VALUES IN (274) ENGINE = InnoDB,
PARTITION P275 VALUES IN (275) ENGINE = InnoDB,
PARTITION P276 VALUES IN (276) ENGINE = InnoDB,
PARTITION P277 VALUES IN (277) ENGINE = InnoDB,
PARTITION P278 VALUES IN (278) ENGINE = InnoDB,
PARTITION P279 VALUES IN (279) ENGINE = InnoDB,
PARTITION P280 VALUES IN (280) ENGINE = InnoDB,
PARTITION P281 VALUES IN (281) ENGINE = InnoDB,
PARTITION P282 VALUES IN (282) ENGINE = InnoDB,
PARTITION P283 VALUES IN (283) ENGINE = InnoDB,
PARTITION P284 VALUES IN (284) ENGINE = InnoDB,
PARTITION P285 VALUES IN (285) ENGINE = InnoDB,
PARTITION P286 VALUES IN (286) ENGINE = InnoDB,
PARTITION P287 VALUES IN (287) ENGINE = InnoDB,
PARTITION P288 VALUES IN (288) ENGINE = InnoDB,
PARTITION P289 VALUES IN (289) ENGINE = InnoDB,
PARTITION P290 VALUES IN (290) ENGINE = InnoDB,
PARTITION P291 VALUES IN (291) ENGINE = InnoDB,
PARTITION P292 VALUES IN (292) ENGINE = InnoDB,
PARTITION P293 VALUES IN (293) ENGINE = InnoDB,
PARTITION P294 VALUES IN (294) ENGINE = InnoDB,
PARTITION P295 VALUES IN (295) ENGINE = InnoDB,
PARTITION P296 VALUES IN (296) ENGINE = InnoDB,
PARTITION P297 VALUES IN (297) ENGINE = InnoDB,
PARTITION P298 VALUES IN (298) ENGINE = InnoDB,
PARTITION P299 VALUES IN (299) ENGINE = InnoDB,
PARTITION P300 VALUES IN (300) ENGINE = InnoDB,
PARTITION P301 VALUES IN (301) ENGINE = InnoDB,
PARTITION P302 VALUES IN (302) ENGINE = InnoDB,
PARTITION P303 VALUES IN (303) ENGINE = InnoDB,
PARTITION P304 VALUES IN (304) ENGINE = InnoDB,
PARTITION P305 VALUES IN (305) ENGINE = InnoDB,
PARTITION P306 VALUES IN (306) ENGINE = InnoDB,
PARTITION P307 VALUES IN (307) ENGINE = InnoDB,
PARTITION P308 VALUES IN (308) ENGINE = InnoDB,
PARTITION P309 VALUES IN (309) ENGINE = InnoDB,
PARTITION P310 VALUES IN (310) ENGINE = InnoDB,
PARTITION P311 VALUES IN (311) ENGINE = InnoDB,
PARTITION P312 VALUES IN (312) ENGINE = InnoDB,
PARTITION P313 VALUES IN (313) ENGINE = InnoDB,
PARTITION P314 VALUES IN (314) ENGINE = InnoDB,
PARTITION P315 VALUES IN (315) ENGINE = InnoDB,
PARTITION P316 VALUES IN (316) ENGINE = InnoDB,
PARTITION P317 VALUES IN (317) ENGINE = InnoDB,
PARTITION P318 VALUES IN (318) ENGINE = InnoDB,
PARTITION P319 VALUES IN (319) ENGINE = InnoDB,
PARTITION P320 VALUES IN (320) ENGINE = InnoDB,
PARTITION P321 VALUES IN (321) ENGINE = InnoDB,
PARTITION P322 VALUES IN (322) ENGINE = InnoDB,
PARTITION P323 VALUES IN (323) ENGINE = InnoDB,
PARTITION P324 VALUES IN (324) ENGINE = InnoDB,
PARTITION P325 VALUES IN (325) ENGINE = InnoDB,
PARTITION P326 VALUES IN (326) ENGINE = InnoDB,
PARTITION P327 VALUES IN (327) ENGINE = InnoDB,
PARTITION P328 VALUES IN (328) ENGINE = InnoDB,
PARTITION P329 VALUES IN (329) ENGINE = InnoDB,
PARTITION P330 VALUES IN (330) ENGINE = InnoDB,
PARTITION P331 VALUES IN (331) ENGINE = InnoDB,
PARTITION P332 VALUES IN (332) ENGINE = InnoDB,
PARTITION P333 VALUES IN (333) ENGINE = InnoDB,
PARTITION P334 VALUES IN (334) ENGINE = InnoDB,
PARTITION P335 VALUES IN (335) ENGINE = InnoDB,
PARTITION P336 VALUES IN (336) ENGINE = InnoDB,
PARTITION P337 VALUES IN (337) ENGINE = InnoDB,
PARTITION P338 VALUES IN (338) ENGINE = InnoDB,
PARTITION P339 VALUES IN (339) ENGINE = InnoDB,
PARTITION P340 VALUES IN (340) ENGINE = InnoDB,
PARTITION P341 VALUES IN (341) ENGINE = InnoDB,
PARTITION P342 VALUES IN (342) ENGINE = InnoDB,
PARTITION P343 VALUES IN (343) ENGINE = InnoDB,
PARTITION P344 VALUES IN (344) ENGINE = InnoDB,
PARTITION P345 VALUES IN (345) ENGINE = InnoDB,
PARTITION P346 VALUES IN (346) ENGINE = InnoDB,
PARTITION P347 VALUES IN (347) ENGINE = InnoDB,
PARTITION P348 VALUES IN (348) ENGINE = InnoDB,
PARTITION P349 VALUES IN (349) ENGINE = InnoDB,
PARTITION P350 VALUES IN (350) ENGINE = InnoDB,
PARTITION P351 VALUES IN (351) ENGINE = InnoDB,
PARTITION P352 VALUES IN (352) ENGINE = InnoDB,
PARTITION P353 VALUES IN (353) ENGINE = InnoDB,
PARTITION P354 VALUES IN (354) ENGINE = InnoDB,
PARTITION P355 VALUES IN (355) ENGINE = InnoDB,
PARTITION P356 VALUES IN (356) ENGINE = InnoDB,
PARTITION P357 VALUES IN (357) ENGINE = InnoDB,
PARTITION P358 VALUES IN (358) ENGINE = InnoDB,
PARTITION P359 VALUES IN (359) ENGINE = InnoDB,
PARTITION P360 VALUES IN (360) ENGINE = InnoDB,
PARTITION P361 VALUES IN (361) ENGINE = InnoDB,
PARTITION P362 VALUES IN (362) ENGINE = InnoDB,
PARTITION P363 VALUES IN (363) ENGINE = InnoDB,
PARTITION P364 VALUES IN (364) ENGINE = InnoDB,
PARTITION P365 VALUES IN (365) ENGINE = InnoDB,
PARTITION P366 VALUES IN (366) ENGINE = InnoDB) */;

for (( i=0;i<220;i++ ));do
sleep 0.01
/data/app/mysql/bin/mysql -uroot -p'root' -h xx.xx.xx.xx -P3306 test -Nse "create table a${i} like cbps_buffmsg"
done