Skip to content

Instantly share code, notes, and snippets.

@kadambkaluskar
Created May 31, 2018 12:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kadambkaluskar/4e2ff8d5be6f625c123b58bc10cb32b0 to your computer and use it in GitHub Desktop.
Save kadambkaluskar/4e2ff8d5be6f625c123b58bc10cb32b0 to your computer and use it in GitHub Desktop.
CREATE TABLE `large_table` (
`user` int(10) NOT NULL,
`mobile` bigint(15) NOT NULL,
`is_first_time` tinyint(1) NOT NULL DEFAULT '1',
`time_send` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`user`,`mobile`),
KEY `userid` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (user)
(PARTITION p1 VALUES LESS THAN (500) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (1000) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (1500) ENGINE = InnoDB,
PARTITION p4 VALUES LESS THAN (2000) ENGINE = InnoDB,
PARTITION p5 VALUES LESS THAN (2500) ENGINE = InnoDB,
PARTITION p6 VALUES LESS THAN (3000) ENGINE = InnoDB,
PARTITION p7 VALUES LESS THAN (3500) ENGINE = InnoDB,
PARTITION p8 VALUES LESS THAN (4000) ENGINE = InnoDB,
PARTITION p9 VALUES LESS THAN (4500) ENGINE = InnoDB,
PARTITION p10 VALUES LESS THAN (5000) ENGINE = InnoDB,
PARTITION p11 VALUES LESS THAN (5500) ENGINE = InnoDB,
PARTITION p12 VALUES LESS THAN (6000) ENGINE = InnoDB,
PARTITION p13 VALUES LESS THAN (6500) ENGINE = InnoDB,
PARTITION p14 VALUES LESS THAN (7000) ENGINE = InnoDB,
PARTITION p15 VALUES LESS THAN (7500) ENGINE = InnoDB,
PARTITION p16 VALUES LESS THAN (8000) ENGINE = InnoDB,
PARTITION p17 VALUES LESS THAN (8500) ENGINE = InnoDB,
PARTITION p18 VALUES LESS THAN (9000) ENGINE = InnoDB,
PARTITION p19 VALUES LESS THAN (9500) ENGINE = InnoDB,
PARTITION p20 VALUES LESS THAN (10000) ENGINE = InnoDB,
PARTITION p21 VALUES LESS THAN (10500) ENGINE = InnoDB,
PARTITION p22 VALUES LESS THAN (11000) ENGINE = InnoDB,
PARTITION p23 VALUES LESS THAN (11500) ENGINE = InnoDB,
PARTITION p24 VALUES LESS THAN (12000) ENGINE = InnoDB,
PARTITION p25 VALUES LESS THAN (12500) ENGINE = InnoDB,
PARTITION p26 VALUES LESS THAN (13000) ENGINE = InnoDB,
PARTITION p27 VALUES LESS THAN (13500) ENGINE = InnoDB,
PARTITION p28 VALUES LESS THAN (14000) ENGINE = InnoDB,
PARTITION p29 VALUES LESS THAN (14500) ENGINE = InnoDB,
PARTITION p30 VALUES LESS THAN (15000) ENGINE = InnoDB,
PARTITION p31 VALUES LESS THAN (15500) ENGINE = InnoDB,
PARTITION p32 VALUES LESS THAN (16000) ENGINE = InnoDB,
PARTITION p33 VALUES LESS THAN (16500) ENGINE = InnoDB,
PARTITION p34 VALUES LESS THAN (17000) ENGINE = InnoDB,
PARTITION p35 VALUES LESS THAN (17500) ENGINE = InnoDB,
PARTITION p36 VALUES LESS THAN (18000) ENGINE = InnoDB,
PARTITION p37 VALUES LESS THAN (18500) ENGINE = InnoDB,
PARTITION p38 VALUES LESS THAN (19000) ENGINE = InnoDB,
PARTITION p39 VALUES LESS THAN (19500) ENGINE = InnoDB,
PARTITION p40 VALUES LESS THAN (20000) ENGINE = InnoDB,
PARTITION p41 VALUES LESS THAN (20500) ENGINE = InnoDB,
PARTITION p42 VALUES LESS THAN (21000) ENGINE = InnoDB,
PARTITION p43 VALUES LESS THAN (21500) ENGINE = InnoDB,
PARTITION p44 VALUES LESS THAN (22000) ENGINE = InnoDB,
PARTITION p45 VALUES LESS THAN (22500) ENGINE = InnoDB,
PARTITION p46 VALUES LESS THAN (23000) ENGINE = InnoDB,
PARTITION p47 VALUES LESS THAN (23500) ENGINE = InnoDB,
PARTITION p48 VALUES LESS THAN (24000) ENGINE = InnoDB,
PARTITION p49 VALUES LESS THAN (24500) ENGINE = InnoDB,
PARTITION p50 VALUES LESS THAN (25000) ENGINE = InnoDB,
PARTITION p51 VALUES LESS THAN (25500) ENGINE = InnoDB,
PARTITION p52 VALUES LESS THAN (26000) ENGINE = InnoDB,
PARTITION p53 VALUES LESS THAN (26500) ENGINE = InnoDB,
PARTITION p54 VALUES LESS THAN (27000) ENGINE = InnoDB,
PARTITION p55 VALUES LESS THAN (27500) ENGINE = InnoDB,
PARTITION p56 VALUES LESS THAN (28000) ENGINE = InnoDB,
PARTITION p57 VALUES LESS THAN (28500) ENGINE = InnoDB,
PARTITION p58 VALUES LESS THAN (29000) ENGINE = InnoDB,
PARTITION p59 VALUES LESS THAN (29500) ENGINE = InnoDB,
PARTITION p60 VALUES LESS THAN (30000) ENGINE = InnoDB,
PARTITION p61 VALUES LESS THAN (30500) ENGINE = InnoDB,
PARTITION p62 VALUES LESS THAN (31000) ENGINE = InnoDB,
PARTITION p63 VALUES LESS THAN (31500) ENGINE = InnoDB,
PARTITION p64 VALUES LESS THAN (32000) ENGINE = InnoDB,
PARTITION p65 VALUES LESS THAN (32500) ENGINE = InnoDB,
PARTITION p66 VALUES LESS THAN (33000) ENGINE = InnoDB,
PARTITION p67 VALUES LESS THAN (33500) ENGINE = InnoDB,
PARTITION p68 VALUES LESS THAN (34000) ENGINE = InnoDB,
PARTITION p69 VALUES LESS THAN (34500) ENGINE = InnoDB,
PARTITION p70 VALUES LESS THAN (35000) ENGINE = InnoDB,
PARTITION p71 VALUES LESS THAN (35500) ENGINE = InnoDB,
PARTITION p72 VALUES LESS THAN (36000) ENGINE = InnoDB,
PARTITION p73 VALUES LESS THAN (36500) ENGINE = InnoDB,
PARTITION p74 VALUES LESS THAN (37000) ENGINE = InnoDB,
PARTITION p75 VALUES LESS THAN (37500) ENGINE = InnoDB,
PARTITION p76 VALUES LESS THAN (38000) ENGINE = InnoDB,
PARTITION p77 VALUES LESS THAN (38500) ENGINE = InnoDB,
PARTITION p78 VALUES LESS THAN (39000) ENGINE = InnoDB,
PARTITION p79 VALUES LESS THAN (39500) ENGINE = InnoDB,
PARTITION p80 VALUES LESS THAN (40000) ENGINE = InnoDB,
PARTITION p81 VALUES LESS THAN (40500) ENGINE = InnoDB,
PARTITION p82 VALUES LESS THAN (41000) ENGINE = InnoDB,
PARTITION p83 VALUES LESS THAN (41500) ENGINE = InnoDB,
PARTITION p84 VALUES LESS THAN (42000) ENGINE = InnoDB,
PARTITION p85 VALUES LESS THAN (42500) ENGINE = InnoDB,
PARTITION p86 VALUES LESS THAN (43000) ENGINE = InnoDB,
PARTITION p87 VALUES LESS THAN (43500) ENGINE = InnoDB,
PARTITION p88 VALUES LESS THAN (44000) ENGINE = InnoDB,
PARTITION p89 VALUES LESS THAN (44500) ENGINE = InnoDB,
PARTITION p90 VALUES LESS THAN (45000) ENGINE = InnoDB,
PARTITION p91 VALUES LESS THAN (45500) ENGINE = InnoDB,
PARTITION p92 VALUES LESS THAN (46000) ENGINE = InnoDB,
PARTITION p93 VALUES LESS THAN (46500) ENGINE = InnoDB,
PARTITION p94 VALUES LESS THAN (47000) ENGINE = InnoDB,
PARTITION p95 VALUES LESS THAN (47500) ENGINE = InnoDB,
PARTITION p96 VALUES LESS THAN (48000) ENGINE = InnoDB,
PARTITION p97 VALUES LESS THAN (48500) ENGINE = InnoDB,
PARTITION p98 VALUES LESS THAN (49000) ENGINE = InnoDB,
PARTITION p99 VALUES LESS THAN (49500) ENGINE = InnoDB,
PARTITION p100 VALUES LESS THAN (50000) ENGINE = InnoDB,
PARTITION p101 VALUES LESS THAN (50500) ENGINE = InnoDB,
PARTITION p102 VALUES LESS THAN (51000) ENGINE = InnoDB,
PARTITION p103 VALUES LESS THAN (51500) ENGINE = InnoDB,
PARTITION p104 VALUES LESS THAN (52000) ENGINE = InnoDB,
PARTITION p105 VALUES LESS THAN (52500) ENGINE = InnoDB,
PARTITION p106 VALUES LESS THAN (53000) ENGINE = InnoDB,
PARTITION p107 VALUES LESS THAN (53500) ENGINE = InnoDB,
PARTITION p108 VALUES LESS THAN (54000) ENGINE = InnoDB,
PARTITION p109 VALUES LESS THAN (54500) ENGINE = InnoDB,
PARTITION p110 VALUES LESS THAN (55000) ENGINE = InnoDB,
PARTITION p111 VALUES LESS THAN (55500) ENGINE = InnoDB,
PARTITION p112 VALUES LESS THAN (56000) ENGINE = InnoDB,
PARTITION p113 VALUES LESS THAN (56500) ENGINE = InnoDB,
PARTITION p114 VALUES LESS THAN (57000) ENGINE = InnoDB,
PARTITION p115 VALUES LESS THAN (57500) ENGINE = InnoDB,
PARTITION p116 VALUES LESS THAN (58000) ENGINE = InnoDB,
PARTITION p117 VALUES LESS THAN (58500) ENGINE = InnoDB,
PARTITION p118 VALUES LESS THAN (59000) ENGINE = InnoDB,
PARTITION p119 VALUES LESS THAN (59500) ENGINE = InnoDB,
PARTITION p120 VALUES LESS THAN (60000) ENGINE = InnoDB,
PARTITION p121 VALUES LESS THAN (60500) ENGINE = InnoDB,
PARTITION p122 VALUES LESS THAN (61000) ENGINE = InnoDB,
PARTITION p123 VALUES LESS THAN (61500) ENGINE = InnoDB,
PARTITION p124 VALUES LESS THAN (62000) ENGINE = InnoDB,
PARTITION p125 VALUES LESS THAN (62500) ENGINE = InnoDB,
PARTITION p126 VALUES LESS THAN (63000) ENGINE = InnoDB,
PARTITION p127 VALUES LESS THAN (63500) ENGINE = InnoDB,
PARTITION p128 VALUES LESS THAN (64000) ENGINE = InnoDB,
PARTITION p129 VALUES LESS THAN (64500) ENGINE = InnoDB,
PARTITION p130 VALUES LESS THAN (65000) ENGINE = InnoDB,
PARTITION p131 VALUES LESS THAN (65500) ENGINE = InnoDB,
PARTITION p132 VALUES LESS THAN (66000) ENGINE = InnoDB,
PARTITION p133 VALUES LESS THAN (66500) ENGINE = InnoDB,
PARTITION p134 VALUES LESS THAN (67000) ENGINE = InnoDB,
PARTITION p135 VALUES LESS THAN (67500) ENGINE = InnoDB,
PARTITION p136 VALUES LESS THAN (68000) ENGINE = InnoDB,
PARTITION p137 VALUES LESS THAN (68500) ENGINE = InnoDB,
PARTITION p138 VALUES LESS THAN (69000) ENGINE = InnoDB,
PARTITION p139 VALUES LESS THAN (69500) ENGINE = InnoDB,
PARTITION p140 VALUES LESS THAN (70000) ENGINE = InnoDB,
PARTITION p141 VALUES LESS THAN (70500) ENGINE = InnoDB,
PARTITION p142 VALUES LESS THAN (71000) ENGINE = InnoDB,
PARTITION p143 VALUES LESS THAN (71500) ENGINE = InnoDB,
PARTITION p144 VALUES LESS THAN (72000) ENGINE = InnoDB,
PARTITION p145 VALUES LESS THAN (72500) ENGINE = InnoDB,
PARTITION p146 VALUES LESS THAN (73000) ENGINE = InnoDB,
PARTITION p147 VALUES LESS THAN (73500) ENGINE = InnoDB,
PARTITION p148 VALUES LESS THAN (74000) ENGINE = InnoDB,
PARTITION p149 VALUES LESS THAN (74500) ENGINE = InnoDB,
PARTITION p150 VALUES LESS THAN (75000) ENGINE = InnoDB,
PARTITION p151 VALUES LESS THAN (75500) ENGINE = InnoDB,
PARTITION p152 VALUES LESS THAN (76000) ENGINE = InnoDB,
PARTITION p153 VALUES LESS THAN (76500) ENGINE = InnoDB,
PARTITION p154 VALUES LESS THAN (77000) ENGINE = InnoDB,
PARTITION p155 VALUES LESS THAN (77500) ENGINE = InnoDB,
PARTITION p156 VALUES LESS THAN (78000) ENGINE = InnoDB,
PARTITION p157 VALUES LESS THAN (78500) ENGINE = InnoDB,
PARTITION p158 VALUES LESS THAN (79000) ENGINE = InnoDB,
PARTITION p159 VALUES LESS THAN (79500) ENGINE = InnoDB,
PARTITION p160 VALUES LESS THAN (80000) ENGINE = InnoDB,
PARTITION p161 VALUES LESS THAN (80500) ENGINE = InnoDB,
PARTITION p162 VALUES LESS THAN (81000) ENGINE = InnoDB,
PARTITION p163 VALUES LESS THAN (81500) ENGINE = InnoDB,
PARTITION p164 VALUES LESS THAN (82000) ENGINE = InnoDB,
PARTITION p165 VALUES LESS THAN (82500) ENGINE = InnoDB,
PARTITION p166 VALUES LESS THAN (83000) ENGINE = InnoDB,
PARTITION p167 VALUES LESS THAN (83500) ENGINE = InnoDB,
PARTITION p168 VALUES LESS THAN (84000) ENGINE = InnoDB,
PARTITION p169 VALUES LESS THAN (84500) ENGINE = InnoDB,
PARTITION p170 VALUES LESS THAN (85000) ENGINE = InnoDB,
PARTITION p171 VALUES LESS THAN (85500) ENGINE = InnoDB,
PARTITION p172 VALUES LESS THAN (86000) ENGINE = InnoDB,
PARTITION p173 VALUES LESS THAN (86500) ENGINE = InnoDB,
PARTITION p174 VALUES LESS THAN (87000) ENGINE = InnoDB,
PARTITION p175 VALUES LESS THAN (87500) ENGINE = InnoDB,
PARTITION p176 VALUES LESS THAN (88000) ENGINE = InnoDB,
PARTITION p177 VALUES LESS THAN (88500) ENGINE = InnoDB,
PARTITION p178 VALUES LESS THAN (89000) ENGINE = InnoDB,
PARTITION p179 VALUES LESS THAN (89500) ENGINE = InnoDB,
PARTITION p180 VALUES LESS THAN (90000) ENGINE = InnoDB,
PARTITION p181 VALUES LESS THAN (90500) ENGINE = InnoDB,
PARTITION p182 VALUES LESS THAN (91000) ENGINE = InnoDB,
PARTITION p183 VALUES LESS THAN (91500) ENGINE = InnoDB,
PARTITION p184 VALUES LESS THAN (92000) ENGINE = InnoDB,
PARTITION p185 VALUES LESS THAN (92500) ENGINE = InnoDB,
PARTITION p186 VALUES LESS THAN (93000) ENGINE = InnoDB,
PARTITION p187 VALUES LESS THAN (93500) ENGINE = InnoDB,
PARTITION p188 VALUES LESS THAN (94000) ENGINE = InnoDB,
PARTITION p189 VALUES LESS THAN (94500) ENGINE = InnoDB,
PARTITION p190 VALUES LESS THAN (95000) ENGINE = InnoDB,
PARTITION p191 VALUES LESS THAN (95500) ENGINE = InnoDB,
PARTITION p192 VALUES LESS THAN (96000) ENGINE = InnoDB,
PARTITION p193 VALUES LESS THAN (96500) ENGINE = InnoDB,
PARTITION p194 VALUES LESS THAN (97000) ENGINE = InnoDB,
PARTITION p195 VALUES LESS THAN (97500) ENGINE = InnoDB,
PARTITION p196 VALUES LESS THAN (98000) ENGINE = InnoDB,
PARTITION p197 VALUES LESS THAN (98500) ENGINE = InnoDB,
PARTITION p198 VALUES LESS THAN (99000) ENGINE = InnoDB,
PARTITION p199 VALUES LESS THAN (99500) ENGINE = InnoDB,
PARTITION p200 VALUES LESS THAN (100000) ENGINE = InnoDB,
PARTITION p201 VALUES LESS THAN (100500) ENGINE = InnoDB,
PARTITION p202 VALUES LESS THAN (101000) ENGINE = InnoDB,
PARTITION p203 VALUES LESS THAN (101500) ENGINE = InnoDB,
PARTITION p204 VALUES LESS THAN (102000) ENGINE = InnoDB,
PARTITION p205 VALUES LESS THAN (102500) ENGINE = InnoDB,
PARTITION p206 VALUES LESS THAN (103000) ENGINE = InnoDB,
PARTITION p207 VALUES LESS THAN (103500) ENGINE = InnoDB,
PARTITION p208 VALUES LESS THAN (104000) ENGINE = InnoDB,
PARTITION p209 VALUES LESS THAN (104500) ENGINE = InnoDB,
PARTITION p210 VALUES LESS THAN (105000) ENGINE = InnoDB,
PARTITION p211 VALUES LESS THAN (105500) ENGINE = InnoDB,
PARTITION p212 VALUES LESS THAN (106000) ENGINE = InnoDB,
PARTITION p213 VALUES LESS THAN (106500) ENGINE = InnoDB,
PARTITION p214 VALUES LESS THAN (107000) ENGINE = InnoDB,
PARTITION p215 VALUES LESS THAN (107500) ENGINE = InnoDB,
PARTITION p216 VALUES LESS THAN (108000) ENGINE = InnoDB,
PARTITION p217 VALUES LESS THAN (108500) ENGINE = InnoDB,
PARTITION p218 VALUES LESS THAN (109000) ENGINE = InnoDB,
PARTITION p219 VALUES LESS THAN (109500) ENGINE = InnoDB,
PARTITION p220 VALUES LESS THAN (110000) ENGINE = InnoDB,
PARTITION p221 VALUES LESS THAN (110500) ENGINE = InnoDB,
PARTITION p222 VALUES LESS THAN (111000) ENGINE = InnoDB,
PARTITION p223 VALUES LESS THAN (111500) ENGINE = InnoDB,
PARTITION p224 VALUES LESS THAN (112000) ENGINE = InnoDB,
PARTITION p225 VALUES LESS THAN (112500) ENGINE = InnoDB,
PARTITION p226 VALUES LESS THAN (113000) ENGINE = InnoDB,
PARTITION p227 VALUES LESS THAN (113500) ENGINE = InnoDB,
PARTITION p228 VALUES LESS THAN (114000) ENGINE = InnoDB,
PARTITION p229 VALUES LESS THAN (114500) ENGINE = InnoDB,
PARTITION p230 VALUES LESS THAN (115000) ENGINE = InnoDB,
PARTITION p231 VALUES LESS THAN (115500) ENGINE = InnoDB,
PARTITION p232 VALUES LESS THAN (116000) ENGINE = InnoDB,
PARTITION p233 VALUES LESS THAN (116500) ENGINE = InnoDB,
PARTITION p234 VALUES LESS THAN (117000) ENGINE = InnoDB,
PARTITION p235 VALUES LESS THAN (117500) ENGINE = InnoDB,
PARTITION p236 VALUES LESS THAN (118000) ENGINE = InnoDB,
PARTITION p237 VALUES LESS THAN (118500) ENGINE = InnoDB,
PARTITION p238 VALUES LESS THAN (119000) ENGINE = InnoDB,
PARTITION p239 VALUES LESS THAN (119500) ENGINE = InnoDB,
PARTITION p240 VALUES LESS THAN (120000) ENGINE = InnoDB,
PARTITION p241 VALUES LESS THAN (120500) ENGINE = InnoDB,
PARTITION p242 VALUES LESS THAN (121000) ENGINE = InnoDB,
PARTITION p243 VALUES LESS THAN (121500) ENGINE = InnoDB,
PARTITION p244 VALUES LESS THAN (122000) ENGINE = InnoDB,
PARTITION p245 VALUES LESS THAN (122500) ENGINE = InnoDB,
PARTITION p246 VALUES LESS THAN (123000) ENGINE = InnoDB,
PARTITION p247 VALUES LESS THAN (123500) ENGINE = InnoDB,
PARTITION p248 VALUES LESS THAN (124000) ENGINE = InnoDB,
PARTITION p249 VALUES LESS THAN (124500) ENGINE = InnoDB,
PARTITION p250 VALUES LESS THAN (125000) ENGINE = InnoDB,
PARTITION p251 VALUES LESS THAN (125500) ENGINE = InnoDB,
PARTITION p252 VALUES LESS THAN (126000) ENGINE = InnoDB,
PARTITION p253 VALUES LESS THAN (126500) ENGINE = InnoDB,
PARTITION p254 VALUES LESS THAN (127000) ENGINE = InnoDB,
PARTITION p255 VALUES LESS THAN (127500) ENGINE = InnoDB,
PARTITION p256 VALUES LESS THAN (128000) ENGINE = InnoDB,
PARTITION p257 VALUES LESS THAN (128500) ENGINE = InnoDB,
PARTITION p258 VALUES LESS THAN (129000) ENGINE = InnoDB,
PARTITION p259 VALUES LESS THAN (129500) ENGINE = InnoDB,
PARTITION p260 VALUES LESS THAN (130000) ENGINE = InnoDB,
PARTITION p261 VALUES LESS THAN (130500) ENGINE = InnoDB,
PARTITION p262 VALUES LESS THAN (131000) ENGINE = InnoDB,
PARTITION p263 VALUES LESS THAN (131500) ENGINE = InnoDB,
PARTITION p264 VALUES LESS THAN (132000) ENGINE = InnoDB,
PARTITION p265 VALUES LESS THAN (132500) ENGINE = InnoDB,
PARTITION p266 VALUES LESS THAN (133000) ENGINE = InnoDB,
PARTITION p267 VALUES LESS THAN (133500) ENGINE = InnoDB,
PARTITION p268 VALUES LESS THAN (134000) ENGINE = InnoDB,
PARTITION p269 VALUES LESS THAN (134500) ENGINE = InnoDB,
PARTITION p270 VALUES LESS THAN (135000) ENGINE = InnoDB,
PARTITION p271 VALUES LESS THAN (135500) ENGINE = InnoDB,
PARTITION p272 VALUES LESS THAN (136000) ENGINE = InnoDB,
PARTITION p273 VALUES LESS THAN (136500) ENGINE = InnoDB,
PARTITION p274 VALUES LESS THAN (137000) ENGINE = InnoDB,
PARTITION p275 VALUES LESS THAN (137500) ENGINE = InnoDB,
PARTITION p276 VALUES LESS THAN (138000) ENGINE = InnoDB,
PARTITION p277 VALUES LESS THAN (138500) ENGINE = InnoDB,
PARTITION p278 VALUES LESS THAN (139000) ENGINE = InnoDB,
PARTITION p279 VALUES LESS THAN (139500) ENGINE = InnoDB,
PARTITION p280 VALUES LESS THAN (140000) ENGINE = InnoDB,
PARTITION p281 VALUES LESS THAN (140500) ENGINE = InnoDB,
PARTITION p282 VALUES LESS THAN (141000) ENGINE = InnoDB,
PARTITION p283 VALUES LESS THAN (141500) ENGINE = InnoDB,
PARTITION p284 VALUES LESS THAN (142000) ENGINE = InnoDB,
PARTITION p285 VALUES LESS THAN (142500) ENGINE = InnoDB,
PARTITION p286 VALUES LESS THAN (143000) ENGINE = InnoDB,
PARTITION p287 VALUES LESS THAN (143500) ENGINE = InnoDB,
PARTITION p288 VALUES LESS THAN (144000) ENGINE = InnoDB,
PARTITION p289 VALUES LESS THAN (144500) ENGINE = InnoDB,
PARTITION p290 VALUES LESS THAN (145000) ENGINE = InnoDB,
PARTITION p291 VALUES LESS THAN (145500) ENGINE = InnoDB,
PARTITION p292 VALUES LESS THAN (146000) ENGINE = InnoDB,
PARTITION p293 VALUES LESS THAN (146500) ENGINE = InnoDB,
PARTITION p294 VALUES LESS THAN (147000) ENGINE = InnoDB,
PARTITION p295 VALUES LESS THAN (147500) ENGINE = InnoDB,
PARTITION p296 VALUES LESS THAN (148000) ENGINE = InnoDB,
PARTITION p297 VALUES LESS THAN (148500) ENGINE = InnoDB,
PARTITION p298 VALUES LESS THAN (149000) ENGINE = InnoDB,
PARTITION p299 VALUES LESS THAN (149500) ENGINE = InnoDB,
PARTITION p300 VALUES LESS THAN (150000) ENGINE = InnoDB,
PARTITION p301 VALUES LESS THAN (150500) ENGINE = InnoDB,
PARTITION p302 VALUES LESS THAN (151000) ENGINE = InnoDB,
PARTITION p303 VALUES LESS THAN (151500) ENGINE = InnoDB,
PARTITION p304 VALUES LESS THAN (152000) ENGINE = InnoDB,
PARTITION p305 VALUES LESS THAN (152500) ENGINE = InnoDB,
PARTITION p306 VALUES LESS THAN (153000) ENGINE = InnoDB,
PARTITION p307 VALUES LESS THAN (153500) ENGINE = InnoDB,
PARTITION p308 VALUES LESS THAN (154000) ENGINE = InnoDB,
PARTITION p309 VALUES LESS THAN (154500) ENGINE = InnoDB,
PARTITION p310 VALUES LESS THAN (155000) ENGINE = InnoDB,
PARTITION p311 VALUES LESS THAN (155500) ENGINE = InnoDB,
PARTITION p312 VALUES LESS THAN (156000) ENGINE = InnoDB,
PARTITION p313 VALUES LESS THAN (156500) ENGINE = InnoDB,
PARTITION p314 VALUES LESS THAN (157000) ENGINE = InnoDB,
PARTITION p315 VALUES LESS THAN (157500) ENGINE = InnoDB,
PARTITION p316 VALUES LESS THAN (158000) ENGINE = InnoDB,
PARTITION p317 VALUES LESS THAN (158500) ENGINE = InnoDB,
PARTITION p318 VALUES LESS THAN (159000) ENGINE = InnoDB,
PARTITION p319 VALUES LESS THAN (159500) ENGINE = InnoDB,
PARTITION p320 VALUES LESS THAN (160000) ENGINE = InnoDB,
PARTITION p321 VALUES LESS THAN (160500) ENGINE = InnoDB,
PARTITION p322 VALUES LESS THAN (161000) ENGINE = InnoDB,
PARTITION p323 VALUES LESS THAN (161500) ENGINE = InnoDB,
PARTITION p324 VALUES LESS THAN (162000) ENGINE = InnoDB,
PARTITION p325 VALUES LESS THAN (162500) ENGINE = InnoDB,
PARTITION p326 VALUES LESS THAN (163000) ENGINE = InnoDB,
PARTITION p327 VALUES LESS THAN (163500) ENGINE = InnoDB,
PARTITION p328 VALUES LESS THAN (164000) ENGINE = InnoDB,
PARTITION p329 VALUES LESS THAN (164500) ENGINE = InnoDB,
PARTITION p330 VALUES LESS THAN (165000) ENGINE = InnoDB,
PARTITION p331 VALUES LESS THAN (165500) ENGINE = InnoDB,
PARTITION p332 VALUES LESS THAN (166000) ENGINE = InnoDB,
PARTITION p333 VALUES LESS THAN (166500) ENGINE = InnoDB,
PARTITION p334 VALUES LESS THAN (167000) ENGINE = InnoDB,
PARTITION p335 VALUES LESS THAN (167500) ENGINE = InnoDB,
PARTITION p336 VALUES LESS THAN (168000) ENGINE = InnoDB,
PARTITION p337 VALUES LESS THAN (168500) ENGINE = InnoDB,
PARTITION p338 VALUES LESS THAN (169000) ENGINE = InnoDB,
PARTITION p339 VALUES LESS THAN (169500) ENGINE = InnoDB,
PARTITION p340 VALUES LESS THAN (170000) ENGINE = InnoDB,
PARTITION p341 VALUES LESS THAN (170500) ENGINE = InnoDB,
PARTITION p342 VALUES LESS THAN (171000) ENGINE = InnoDB,
PARTITION p343 VALUES LESS THAN (171500) ENGINE = InnoDB,
PARTITION p344 VALUES LESS THAN (172000) ENGINE = InnoDB,
PARTITION p345 VALUES LESS THAN (172500) ENGINE = InnoDB,
PARTITION p346 VALUES LESS THAN (173000) ENGINE = InnoDB,
PARTITION p347 VALUES LESS THAN (173500) ENGINE = InnoDB,
PARTITION p348 VALUES LESS THAN (174000) ENGINE = InnoDB,
PARTITION p349 VALUES LESS THAN (174500) ENGINE = InnoDB,
PARTITION p350 VALUES LESS THAN (175000) ENGINE = InnoDB,
PARTITION p351 VALUES LESS THAN (175500) ENGINE = InnoDB,
PARTITION p352 VALUES LESS THAN (176000) ENGINE = InnoDB,
PARTITION p353 VALUES LESS THAN (176500) ENGINE = InnoDB,
PARTITION p354 VALUES LESS THAN (177000) ENGINE = InnoDB,
PARTITION p355 VALUES LESS THAN (177500) ENGINE = InnoDB,
PARTITION p356 VALUES LESS THAN (178000) ENGINE = InnoDB,
PARTITION p357 VALUES LESS THAN (178500) ENGINE = InnoDB,
PARTITION p358 VALUES LESS THAN (179000) ENGINE = InnoDB,
PARTITION p359 VALUES LESS THAN (179500) ENGINE = InnoDB,
PARTITION p360 VALUES LESS THAN (180000) ENGINE = InnoDB,
PARTITION p361 VALUES LESS THAN (180500) ENGINE = InnoDB,
PARTITION p362 VALUES LESS THAN (181000) ENGINE = InnoDB,
PARTITION p363 VALUES LESS THAN (181500) ENGINE = InnoDB,
PARTITION p364 VALUES LESS THAN (182000) ENGINE = InnoDB,
PARTITION p365 VALUES LESS THAN (182500) ENGINE = InnoDB,
PARTITION p366 VALUES LESS THAN (183000) ENGINE = InnoDB,
PARTITION p367 VALUES LESS THAN (183500) ENGINE = InnoDB,
PARTITION p368 VALUES LESS THAN (184000) ENGINE = InnoDB,
PARTITION p369 VALUES LESS THAN (184500) ENGINE = InnoDB,
PARTITION p370 VALUES LESS THAN (185000) ENGINE = InnoDB,
PARTITION p371 VALUES LESS THAN (185500) ENGINE = InnoDB,
PARTITION p372 VALUES LESS THAN (186000) ENGINE = InnoDB,
PARTITION p373 VALUES LESS THAN (186500) ENGINE = InnoDB,
PARTITION p374 VALUES LESS THAN (187000) ENGINE = InnoDB,
PARTITION p375 VALUES LESS THAN (187500) ENGINE = InnoDB,
PARTITION p376 VALUES LESS THAN (188000) ENGINE = InnoDB,
PARTITION p377 VALUES LESS THAN (188500) ENGINE = InnoDB,
PARTITION p378 VALUES LESS THAN (189000) ENGINE = InnoDB,
PARTITION p379 VALUES LESS THAN (189500) ENGINE = InnoDB,
PARTITION p380 VALUES LESS THAN (190000) ENGINE = InnoDB,
PARTITION p381 VALUES LESS THAN (190500) ENGINE = InnoDB,
PARTITION p382 VALUES LESS THAN (191000) ENGINE = InnoDB,
PARTITION p383 VALUES LESS THAN (191500) ENGINE = InnoDB,
PARTITION p384 VALUES LESS THAN (192000) ENGINE = InnoDB,
PARTITION p385 VALUES LESS THAN (192500) ENGINE = InnoDB,
PARTITION p386 VALUES LESS THAN (193000) ENGINE = InnoDB,
PARTITION p387 VALUES LESS THAN (193500) ENGINE = InnoDB,
PARTITION p388 VALUES LESS THAN (194000) ENGINE = InnoDB,
PARTITION p389 VALUES LESS THAN (194500) ENGINE = InnoDB,
PARTITION p390 VALUES LESS THAN (195000) ENGINE = InnoDB,
PARTITION p391 VALUES LESS THAN (195500) ENGINE = InnoDB,
PARTITION p392 VALUES LESS THAN (196000) ENGINE = InnoDB,
PARTITION p393 VALUES LESS THAN (196500) ENGINE = InnoDB,
PARTITION p394 VALUES LESS THAN (197000) ENGINE = InnoDB,
PARTITION p395 VALUES LESS THAN (197500) ENGINE = InnoDB,
PARTITION p396 VALUES LESS THAN (198000) ENGINE = InnoDB,
PARTITION p397 VALUES LESS THAN (198500) ENGINE = InnoDB,
PARTITION p398 VALUES LESS THAN (199000) ENGINE = InnoDB,
PARTITION p399 VALUES LESS THAN (199500) ENGINE = InnoDB,
PARTITION p400 VALUES LESS THAN (200000) ENGINE = InnoDB,
PARTITION p0 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment