73
73
`f_char1` char(20) DEFAULT NULL,
74
74
`f_char2` char(20) DEFAULT NULL,
75
75
`f_charbig` varchar(1000) DEFAULT NULL
76
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) PARTITIONS 2 */
76
) ENGINE=MyISAM DEFAULT CHARSET=latin1
77
/*!50100 PARTITION BY HASH (f_int1)
538
540
`f_char1` char(20) DEFAULT NULL,
539
541
`f_char2` char(20) DEFAULT NULL,
540
542
`f_charbig` varchar(1000) DEFAULT NULL
541
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) PARTITIONS 5 */
543
) ENGINE=MyISAM DEFAULT CHARSET=latin1
544
/*!50100 PARTITION BY KEY (f_int1)
1017
1021
`f_char1` char(20) DEFAULT NULL,
1018
1022
`f_char2` char(20) DEFAULT NULL,
1019
1023
`f_charbig` varchar(1000) DEFAULT NULL
1020
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
1024
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1025
/*!50100 PARTITION BY LIST (MOD(f_int1,4))
1026
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
1027
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
1028
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
1029
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
1030
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
1031
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
1032
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
1033
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
1022
1035
unified filelist
1500
1513
`f_char1` char(20) DEFAULT NULL,
1501
1514
`f_char2` char(20) DEFAULT NULL,
1502
1515
`f_charbig` varchar(1000) DEFAULT NULL
1503
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
1516
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1517
/*!50100 PARTITION BY RANGE (f_int1)
1518
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
1519
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
1520
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
1521
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
1522
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
1523
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
1505
1525
unified filelist
1973
1993
`f_char1` char(20) DEFAULT NULL,
1974
1994
`f_char2` char(20) DEFAULT NULL,
1975
1995
`f_charbig` varchar(1000) DEFAULT NULL
1976
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
1996
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1997
/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
1998
SUBPARTITION BY HASH (f_int1)
2000
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
2001
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
2002
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
2003
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
1978
2005
unified filelist
1979
2006
t1#P#parta#SP#partasp0.MYD
2458
2485
`f_char1` char(20) DEFAULT NULL,
2459
2486
`f_char2` char(20) DEFAULT NULL,
2460
2487
`f_charbig` varchar(1000) DEFAULT NULL
2461
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
2488
) ENGINE=MyISAM DEFAULT CHARSET=latin1
2489
/*!50100 PARTITION BY RANGE (f_int1)
2490
SUBPARTITION BY KEY (f_int1)
2491
(PARTITION part1 VALUES LESS THAN (0)
2492
(SUBPARTITION subpart11 ENGINE = MyISAM,
2493
SUBPARTITION subpart12 ENGINE = MyISAM),
2494
PARTITION part2 VALUES LESS THAN (5)
2495
(SUBPARTITION subpart21 ENGINE = MyISAM,
2496
SUBPARTITION subpart22 ENGINE = MyISAM),
2497
PARTITION part3 VALUES LESS THAN (10)
2498
(SUBPARTITION subpart31 ENGINE = MyISAM,
2499
SUBPARTITION subpart32 ENGINE = MyISAM),
2500
PARTITION part4 VALUES LESS THAN (2147483646)
2501
(SUBPARTITION subpart41 ENGINE = MyISAM,
2502
SUBPARTITION subpart42 ENGINE = MyISAM)) */
2463
2504
unified filelist
2464
2505
t1#P#part1#SP#subpart11.MYD
2939
2980
`f_char1` char(20) DEFAULT NULL,
2940
2981
`f_char2` char(20) DEFAULT NULL,
2941
2982
`f_charbig` varchar(1000) DEFAULT NULL
2942
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
2983
) ENGINE=MyISAM DEFAULT CHARSET=latin1
2984
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
2985
SUBPARTITION BY HASH (f_int1 + 1)
2986
(PARTITION part1 VALUES IN (0)
2987
(SUBPARTITION sp11 ENGINE = MyISAM,
2988
SUBPARTITION sp12 ENGINE = MyISAM),
2989
PARTITION part2 VALUES IN (1)
2990
(SUBPARTITION sp21 ENGINE = MyISAM,
2991
SUBPARTITION sp22 ENGINE = MyISAM),
2992
PARTITION part3 VALUES IN (2)
2993
(SUBPARTITION sp31 ENGINE = MyISAM,
2994
SUBPARTITION sp32 ENGINE = MyISAM),
2995
PARTITION part4 VALUES IN (NULL)
2996
(SUBPARTITION sp41 ENGINE = MyISAM,
2997
SUBPARTITION sp42 ENGINE = MyISAM)) */
2944
2999
unified filelist
2945
3000
t1#P#part1#SP#sp11.MYD
3420
3475
`f_char1` char(20) DEFAULT NULL,
3421
3476
`f_char2` char(20) DEFAULT NULL,
3422
3477
`f_charbig` varchar(1000) DEFAULT NULL
3423
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
3478
) ENGINE=MyISAM DEFAULT CHARSET=latin1
3479
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
3480
SUBPARTITION BY KEY (f_int1)
3482
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
3483
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
3484
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
3425
3486
unified filelist
3426
3487
t1#P#part1#SP#part1sp0.MYD
3902
3963
`f_char2` char(20) DEFAULT NULL,
3903
3964
`f_charbig` varchar(1000) DEFAULT NULL,
3904
3965
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
3905
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) PARTITIONS 2 */
3966
) ENGINE=MyISAM DEFAULT CHARSET=latin1
3967
/*!50100 PARTITION BY HASH (f_int1)
3907
3970
unified filelist
4419
4482
`f_char2` char(20) DEFAULT NULL,
4420
4483
`f_charbig` varchar(1000) DEFAULT NULL,
4421
4484
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
4422
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) PARTITIONS 5 */
4485
) ENGINE=MyISAM DEFAULT CHARSET=latin1
4486
/*!50100 PARTITION BY KEY (f_int1)
4424
4489
unified filelist
4950
5015
`f_char2` char(20) DEFAULT NULL,
4951
5016
`f_charbig` varchar(1000) DEFAULT NULL,
4952
5017
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
4953
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
5018
) ENGINE=MyISAM DEFAULT CHARSET=latin1
5019
/*!50100 PARTITION BY LIST (MOD(f_int1,4))
5020
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
5021
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
5022
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
5023
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
5024
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
5025
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
5026
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
5027
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
4955
5029
unified filelist
5485
5559
`f_char2` char(20) DEFAULT NULL,
5486
5560
`f_charbig` varchar(1000) DEFAULT NULL,
5487
5561
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
5488
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
5562
) ENGINE=MyISAM DEFAULT CHARSET=latin1
5563
/*!50100 PARTITION BY RANGE (f_int1)
5564
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
5565
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
5566
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
5567
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
5568
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
5569
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
5490
5571
unified filelist
6010
6091
`f_char2` char(20) DEFAULT NULL,
6011
6092
`f_charbig` varchar(1000) DEFAULT NULL,
6012
6093
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
6013
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
6094
) ENGINE=MyISAM DEFAULT CHARSET=latin1
6095
/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
6096
SUBPARTITION BY HASH (f_int1)
6098
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
6099
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
6100
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
6101
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
6015
6103
unified filelist
6016
6104
t1#P#parta#SP#partasp0.MYD
6547
6635
`f_char2` char(20) DEFAULT NULL,
6548
6636
`f_charbig` varchar(1000) DEFAULT NULL,
6549
6637
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
6550
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
6638
) ENGINE=MyISAM DEFAULT CHARSET=latin1
6639
/*!50100 PARTITION BY RANGE (f_int1)
6640
SUBPARTITION BY KEY (f_int1)
6641
(PARTITION part1 VALUES LESS THAN (0)
6642
(SUBPARTITION subpart11 ENGINE = MyISAM,
6643
SUBPARTITION subpart12 ENGINE = MyISAM),
6644
PARTITION part2 VALUES LESS THAN (5)
6645
(SUBPARTITION subpart21 ENGINE = MyISAM,
6646
SUBPARTITION subpart22 ENGINE = MyISAM),
6647
PARTITION part3 VALUES LESS THAN (10)
6648
(SUBPARTITION subpart31 ENGINE = MyISAM,
6649
SUBPARTITION subpart32 ENGINE = MyISAM),
6650
PARTITION part4 VALUES LESS THAN (2147483646)
6651
(SUBPARTITION subpart41 ENGINE = MyISAM,
6652
SUBPARTITION subpart42 ENGINE = MyISAM)) */
6552
6654
unified filelist
6553
6655
t1#P#part1#SP#subpart11.MYD
7080
7182
`f_char2` char(20) DEFAULT NULL,
7081
7183
`f_charbig` varchar(1000) DEFAULT NULL,
7082
7184
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
7083
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
7185
) ENGINE=MyISAM DEFAULT CHARSET=latin1
7186
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
7187
SUBPARTITION BY HASH (f_int1 + 1)
7188
(PARTITION part1 VALUES IN (0)
7189
(SUBPARTITION sp11 ENGINE = MyISAM,
7190
SUBPARTITION sp12 ENGINE = MyISAM),
7191
PARTITION part2 VALUES IN (1)
7192
(SUBPARTITION sp21 ENGINE = MyISAM,
7193
SUBPARTITION sp22 ENGINE = MyISAM),
7194
PARTITION part3 VALUES IN (2)
7195
(SUBPARTITION sp31 ENGINE = MyISAM,
7196
SUBPARTITION sp32 ENGINE = MyISAM),
7197
PARTITION part4 VALUES IN (NULL)
7198
(SUBPARTITION sp41 ENGINE = MyISAM,
7199
SUBPARTITION sp42 ENGINE = MyISAM)) */
7085
7201
unified filelist
7086
7202
t1#P#part1#SP#sp11.MYD
7613
7729
`f_char2` char(20) DEFAULT NULL,
7614
7730
`f_charbig` varchar(1000) DEFAULT NULL,
7615
7731
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
7616
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
7732
) ENGINE=MyISAM DEFAULT CHARSET=latin1
7733
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
7734
SUBPARTITION BY KEY (f_int1)
7736
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
7737
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
7738
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
7618
7740
unified filelist
7619
7741
t1#P#part1#SP#part1sp0.MYD
8145
8267
`f_char2` char(20) DEFAULT NULL,
8146
8268
`f_charbig` varchar(1000) DEFAULT NULL,
8147
8269
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
8148
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) PARTITIONS 2 */
8270
) ENGINE=MyISAM DEFAULT CHARSET=latin1
8271
/*!50100 PARTITION BY HASH (f_int1)
8150
8274
unified filelist
8662
8786
`f_char2` char(20) DEFAULT NULL,
8663
8787
`f_charbig` varchar(1000) DEFAULT NULL,
8664
8788
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
8665
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) PARTITIONS 5 */
8789
) ENGINE=MyISAM DEFAULT CHARSET=latin1
8790
/*!50100 PARTITION BY KEY (f_int1)
8667
8793
unified filelist
9193
9319
`f_char2` char(20) DEFAULT NULL,
9194
9320
`f_charbig` varchar(1000) DEFAULT NULL,
9195
9321
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
9196
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
9322
) ENGINE=MyISAM DEFAULT CHARSET=latin1
9323
/*!50100 PARTITION BY LIST (MOD(f_int1,4))
9324
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
9325
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
9326
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
9327
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
9328
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
9329
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
9330
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
9331
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
9198
9333
unified filelist
9728
9863
`f_char2` char(20) DEFAULT NULL,
9729
9864
`f_charbig` varchar(1000) DEFAULT NULL,
9730
9865
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
9731
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
9866
) ENGINE=MyISAM DEFAULT CHARSET=latin1
9867
/*!50100 PARTITION BY RANGE (f_int1)
9868
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
9869
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
9870
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
9871
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
9872
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
9873
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
9733
9875
unified filelist
10253
10395
`f_char2` char(20) DEFAULT NULL,
10254
10396
`f_charbig` varchar(1000) DEFAULT NULL,
10255
10397
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
10256
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
10398
) ENGINE=MyISAM DEFAULT CHARSET=latin1
10399
/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
10400
SUBPARTITION BY HASH (f_int1)
10402
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
10403
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
10404
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
10405
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
10258
10407
unified filelist
10259
10408
t1#P#parta#SP#partasp0.MYD
10790
10939
`f_char2` char(20) DEFAULT NULL,
10791
10940
`f_charbig` varchar(1000) DEFAULT NULL,
10792
10941
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
10793
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
10942
) ENGINE=MyISAM DEFAULT CHARSET=latin1
10943
/*!50100 PARTITION BY RANGE (f_int1)
10944
SUBPARTITION BY KEY (f_int1)
10945
(PARTITION part1 VALUES LESS THAN (0)
10946
(SUBPARTITION subpart11 ENGINE = MyISAM,
10947
SUBPARTITION subpart12 ENGINE = MyISAM),
10948
PARTITION part2 VALUES LESS THAN (5)
10949
(SUBPARTITION subpart21 ENGINE = MyISAM,
10950
SUBPARTITION subpart22 ENGINE = MyISAM),
10951
PARTITION part3 VALUES LESS THAN (10)
10952
(SUBPARTITION subpart31 ENGINE = MyISAM,
10953
SUBPARTITION subpart32 ENGINE = MyISAM),
10954
PARTITION part4 VALUES LESS THAN (2147483646)
10955
(SUBPARTITION subpart41 ENGINE = MyISAM,
10956
SUBPARTITION subpart42 ENGINE = MyISAM)) */
10795
10958
unified filelist
10796
10959
t1#P#part1#SP#subpart11.MYD
11323
11486
`f_char2` char(20) DEFAULT NULL,
11324
11487
`f_charbig` varchar(1000) DEFAULT NULL,
11325
11488
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
11326
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
11489
) ENGINE=MyISAM DEFAULT CHARSET=latin1
11490
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
11491
SUBPARTITION BY HASH (f_int1 + 1)
11492
(PARTITION part1 VALUES IN (0)
11493
(SUBPARTITION sp11 ENGINE = MyISAM,
11494
SUBPARTITION sp12 ENGINE = MyISAM),
11495
PARTITION part2 VALUES IN (1)
11496
(SUBPARTITION sp21 ENGINE = MyISAM,
11497
SUBPARTITION sp22 ENGINE = MyISAM),
11498
PARTITION part3 VALUES IN (2)
11499
(SUBPARTITION sp31 ENGINE = MyISAM,
11500
SUBPARTITION sp32 ENGINE = MyISAM),
11501
PARTITION part4 VALUES IN (NULL)
11502
(SUBPARTITION sp41 ENGINE = MyISAM,
11503
SUBPARTITION sp42 ENGINE = MyISAM)) */
11328
11505
unified filelist
11329
11506
t1#P#part1#SP#sp11.MYD
11856
12033
`f_char2` char(20) DEFAULT NULL,
11857
12034
`f_charbig` varchar(1000) DEFAULT NULL,
11858
12035
UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
11859
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
12036
) ENGINE=MyISAM DEFAULT CHARSET=latin1
12037
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
12038
SUBPARTITION BY KEY (f_int1)
12040
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
12041
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
12042
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
11861
12044
unified filelist
11862
12045
t1#P#part1#SP#part1sp0.MYD
12391
12574
`f_char1` char(20) DEFAULT NULL,
12392
12575
`f_char2` char(20) DEFAULT NULL,
12393
12576
`f_charbig` varchar(1000) DEFAULT NULL
12394
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) PARTITIONS 2 */
12577
) ENGINE=MyISAM DEFAULT CHARSET=latin1
12578
/*!50100 PARTITION BY HASH (f_int1)
12396
12581
unified filelist
12857
13042
`f_char1` char(20) DEFAULT NULL,
12858
13043
`f_char2` char(20) DEFAULT NULL,
12859
13044
`f_charbig` varchar(1000) DEFAULT NULL
12860
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) PARTITIONS 5 */
13045
) ENGINE=MyISAM DEFAULT CHARSET=latin1
13046
/*!50100 PARTITION BY KEY (f_int1)
12862
13049
unified filelist
13337
13524
`f_char1` char(20) DEFAULT NULL,
13338
13525
`f_char2` char(20) DEFAULT NULL,
13339
13526
`f_charbig` varchar(1000) DEFAULT NULL
13340
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
13527
) ENGINE=MyISAM DEFAULT CHARSET=latin1
13528
/*!50100 PARTITION BY LIST (MOD(f_int1,4))
13529
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
13530
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
13531
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
13532
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
13533
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
13534
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
13535
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
13536
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
13342
13538
unified filelist
13343
13539
t1#P#part0.MYD
13821
14017
`f_char1` char(20) DEFAULT NULL,
13822
14018
`f_char2` char(20) DEFAULT NULL,
13823
14019
`f_charbig` varchar(1000) DEFAULT NULL
13824
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
14020
) ENGINE=MyISAM DEFAULT CHARSET=latin1
14021
/*!50100 PARTITION BY RANGE (f_int1)
14022
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
14023
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
14024
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
14025
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
14026
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
14027
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
13826
14029
unified filelist
13827
14030
t1#P#parta.MYD
14299
14502
`f_char1` char(20) DEFAULT NULL,
14300
14503
`f_char2` char(20) DEFAULT NULL,
14301
14504
`f_charbig` varchar(1000) DEFAULT NULL
14302
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
14505
) ENGINE=MyISAM DEFAULT CHARSET=latin1
14506
/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
14507
SUBPARTITION BY HASH (f_int1)
14509
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
14510
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
14511
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
14512
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
14304
14514
unified filelist
14305
14515
t1#P#parta#SP#partasp0.MYD
14785
14995
`f_char1` char(20) DEFAULT NULL,
14786
14996
`f_char2` char(20) DEFAULT NULL,
14787
14997
`f_charbig` varchar(1000) DEFAULT NULL
14788
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
14998
) ENGINE=MyISAM DEFAULT CHARSET=latin1
14999
/*!50100 PARTITION BY RANGE (f_int1)
15000
SUBPARTITION BY KEY (f_int1)
15001
(PARTITION part1 VALUES LESS THAN (0)
15002
(SUBPARTITION subpart11 ENGINE = MyISAM,
15003
SUBPARTITION subpart12 ENGINE = MyISAM),
15004
PARTITION part2 VALUES LESS THAN (5)
15005
(SUBPARTITION subpart21 ENGINE = MyISAM,
15006
SUBPARTITION subpart22 ENGINE = MyISAM),
15007
PARTITION part3 VALUES LESS THAN (10)
15008
(SUBPARTITION subpart31 ENGINE = MyISAM,
15009
SUBPARTITION subpart32 ENGINE = MyISAM),
15010
PARTITION part4 VALUES LESS THAN (2147483646)
15011
(SUBPARTITION subpart41 ENGINE = MyISAM,
15012
SUBPARTITION subpart42 ENGINE = MyISAM)) */
14790
15014
unified filelist
14791
15015
t1#P#part1#SP#subpart11.MYD
15271
15495
`f_char1` char(20) DEFAULT NULL,
15272
15496
`f_char2` char(20) DEFAULT NULL,
15273
15497
`f_charbig` varchar(1000) DEFAULT NULL
15274
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
15498
) ENGINE=MyISAM DEFAULT CHARSET=latin1
15499
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
15500
SUBPARTITION BY HASH (f_int1 + 1)
15501
(PARTITION part1 VALUES IN (0)
15502
(SUBPARTITION sp11 ENGINE = MyISAM,
15503
SUBPARTITION sp12 ENGINE = MyISAM),
15504
PARTITION part2 VALUES IN (1)
15505
(SUBPARTITION sp21 ENGINE = MyISAM,
15506
SUBPARTITION sp22 ENGINE = MyISAM),
15507
PARTITION part3 VALUES IN (2)
15508
(SUBPARTITION sp31 ENGINE = MyISAM,
15509
SUBPARTITION sp32 ENGINE = MyISAM),
15510
PARTITION part4 VALUES IN (NULL)
15511
(SUBPARTITION sp41 ENGINE = MyISAM,
15512
SUBPARTITION sp42 ENGINE = MyISAM)) */
15276
15514
unified filelist
15277
15515
t1#P#part1#SP#sp11.MYD
15753
15991
`f_char1` char(20) DEFAULT NULL,
15754
15992
`f_char2` char(20) DEFAULT NULL,
15755
15993
`f_charbig` varchar(1000) DEFAULT NULL
15756
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
15994
) ENGINE=MyISAM DEFAULT CHARSET=latin1
15995
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
15996
SUBPARTITION BY KEY (f_int1)
15998
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
15999
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
16000
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
15758
16002
unified filelist
15759
16003
t1#P#part1#SP#part1sp0.MYD
16234
16478
`f_char1` char(20) DEFAULT NULL,
16235
16479
`f_char2` char(20) DEFAULT NULL,
16236
16480
`f_charbig` varchar(1000) DEFAULT NULL
16237
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1 + f_int2) PARTITIONS 2 */
16481
) ENGINE=MyISAM DEFAULT CHARSET=latin1
16482
/*!50100 PARTITION BY HASH (f_int1 + f_int2)
16239
16485
unified filelist
16700
16946
`f_char1` char(20) DEFAULT NULL,
16701
16947
`f_char2` char(20) DEFAULT NULL,
16702
16948
`f_charbig` varchar(1000) DEFAULT NULL
16703
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1,f_int2) PARTITIONS 5 */
16949
) ENGINE=MyISAM DEFAULT CHARSET=latin1
16950
/*!50100 PARTITION BY KEY (f_int1,f_int2)
16705
16953
unified filelist
17180
17428
`f_char1` char(20) DEFAULT NULL,
17181
17429
`f_char2` char(20) DEFAULT NULL,
17182
17430
`f_charbig` varchar(1000) DEFAULT NULL
17183
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
17431
) ENGINE=MyISAM DEFAULT CHARSET=latin1
17432
/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4))
17433
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
17434
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
17435
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
17436
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
17437
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
17438
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
17439
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
17440
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
17185
17442
unified filelist
17186
17443
t1#P#part0.MYD
17664
17921
`f_char1` char(20) DEFAULT NULL,
17665
17922
`f_char2` char(20) DEFAULT NULL,
17666
17923
`f_charbig` varchar(1000) DEFAULT NULL
17667
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
17924
) ENGINE=MyISAM DEFAULT CHARSET=latin1
17925
/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2)
17926
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
17927
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
17928
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
17929
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
17930
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
17931
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
17669
17933
unified filelist
17670
17934
t1#P#parta.MYD
18142
18406
`f_char1` char(20) DEFAULT NULL,
18143
18407
`f_char2` char(20) DEFAULT NULL,
18144
18408
`f_charbig` varchar(1000) DEFAULT NULL
18145
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int2) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
18409
) ENGINE=MyISAM DEFAULT CHARSET=latin1
18410
/*!50100 PARTITION BY RANGE (f_int1)
18411
SUBPARTITION BY HASH (f_int2)
18413
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
18414
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
18415
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
18416
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
18147
18418
unified filelist
18148
18419
t1#P#parta#SP#partasp0.MYD
18628
18899
`f_char1` char(20) DEFAULT NULL,
18629
18900
`f_char2` char(20) DEFAULT NULL,
18630
18901
`f_charbig` varchar(1000) DEFAULT NULL
18631
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int2) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
18902
) ENGINE=MyISAM DEFAULT CHARSET=latin1
18903
/*!50100 PARTITION BY RANGE (f_int1)
18904
SUBPARTITION BY KEY (f_int2)
18905
(PARTITION part1 VALUES LESS THAN (0)
18906
(SUBPARTITION subpart11 ENGINE = MyISAM,
18907
SUBPARTITION subpart12 ENGINE = MyISAM),
18908
PARTITION part2 VALUES LESS THAN (5)
18909
(SUBPARTITION subpart21 ENGINE = MyISAM,
18910
SUBPARTITION subpart22 ENGINE = MyISAM),
18911
PARTITION part3 VALUES LESS THAN (10)
18912
(SUBPARTITION subpart31 ENGINE = MyISAM,
18913
SUBPARTITION subpart32 ENGINE = MyISAM),
18914
PARTITION part4 VALUES LESS THAN (2147483646)
18915
(SUBPARTITION subpart41 ENGINE = MyISAM,
18916
SUBPARTITION subpart42 ENGINE = MyISAM)) */
18633
18918
unified filelist
18634
18919
t1#P#part1#SP#subpart11.MYD
19114
19399
`f_char1` char(20) DEFAULT NULL,
19115
19400
`f_char2` char(20) DEFAULT NULL,
19116
19401
`f_charbig` varchar(1000) DEFAULT NULL
19117
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int2 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
19402
) ENGINE=MyISAM DEFAULT CHARSET=latin1
19403
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
19404
SUBPARTITION BY HASH (f_int2 + 1)
19405
(PARTITION part1 VALUES IN (0)
19406
(SUBPARTITION sp11 ENGINE = MyISAM,
19407
SUBPARTITION sp12 ENGINE = MyISAM),
19408
PARTITION part2 VALUES IN (1)
19409
(SUBPARTITION sp21 ENGINE = MyISAM,
19410
SUBPARTITION sp22 ENGINE = MyISAM),
19411
PARTITION part3 VALUES IN (2)
19412
(SUBPARTITION sp31 ENGINE = MyISAM,
19413
SUBPARTITION sp32 ENGINE = MyISAM),
19414
PARTITION part4 VALUES IN (NULL)
19415
(SUBPARTITION sp41 ENGINE = MyISAM,
19416
SUBPARTITION sp42 ENGINE = MyISAM)) */
19119
19418
unified filelist
19120
19419
t1#P#part1#SP#sp11.MYD
19596
19895
`f_char1` char(20) DEFAULT NULL,
19597
19896
`f_char2` char(20) DEFAULT NULL,
19598
19897
`f_charbig` varchar(1000) DEFAULT NULL
19599
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int2) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
19898
) ENGINE=MyISAM DEFAULT CHARSET=latin1
19899
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
19900
SUBPARTITION BY KEY (f_int2)
19902
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
19903
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
19904
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
19601
19906
unified filelist
19602
19907
t1#P#part1#SP#part1sp0.MYD
20079
20384
`f_char2` char(20) DEFAULT NULL,
20080
20385
`f_charbig` varchar(1000) DEFAULT NULL,
20081
20386
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
20082
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) PARTITIONS 2 */
20387
) ENGINE=MyISAM DEFAULT CHARSET=latin1
20388
/*!50100 PARTITION BY HASH (f_int1)
20084
20391
unified filelist
20597
20904
`f_char2` char(20) DEFAULT NULL,
20598
20905
`f_charbig` varchar(1000) DEFAULT NULL,
20599
20906
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
20600
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) PARTITIONS 5 */
20907
) ENGINE=MyISAM DEFAULT CHARSET=latin1
20908
/*!50100 PARTITION BY KEY (f_int1)
20602
20911
unified filelist
21129
21438
`f_char2` char(20) DEFAULT NULL,
21130
21439
`f_charbig` varchar(1000) DEFAULT NULL,
21131
21440
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
21132
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
21441
) ENGINE=MyISAM DEFAULT CHARSET=latin1
21442
/*!50100 PARTITION BY LIST (MOD(f_int1,4))
21443
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
21444
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
21445
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
21446
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
21447
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
21448
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
21449
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
21450
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
21134
21452
unified filelist
21135
21453
t1#P#part0.MYD
21665
21983
`f_char2` char(20) DEFAULT NULL,
21666
21984
`f_charbig` varchar(1000) DEFAULT NULL,
21667
21985
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
21668
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
21986
) ENGINE=MyISAM DEFAULT CHARSET=latin1
21987
/*!50100 PARTITION BY RANGE (f_int1)
21988
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
21989
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
21990
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
21991
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
21992
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
21993
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
21670
21995
unified filelist
21671
21996
t1#P#parta.MYD
22195
22520
`f_char2` char(20) DEFAULT NULL,
22196
22521
`f_charbig` varchar(1000) DEFAULT NULL,
22197
22522
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
22198
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
22523
) ENGINE=MyISAM DEFAULT CHARSET=latin1
22524
/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
22525
SUBPARTITION BY HASH (f_int1)
22527
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
22528
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
22529
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
22530
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
22200
22532
unified filelist
22201
22533
t1#P#parta#SP#partasp0.MYD
22733
23065
`f_char2` char(20) DEFAULT NULL,
22734
23066
`f_charbig` varchar(1000) DEFAULT NULL,
22735
23067
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
22736
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
23068
) ENGINE=MyISAM DEFAULT CHARSET=latin1
23069
/*!50100 PARTITION BY RANGE (f_int1)
23070
SUBPARTITION BY KEY (f_int1)
23071
(PARTITION part1 VALUES LESS THAN (0)
23072
(SUBPARTITION subpart11 ENGINE = MyISAM,
23073
SUBPARTITION subpart12 ENGINE = MyISAM),
23074
PARTITION part2 VALUES LESS THAN (5)
23075
(SUBPARTITION subpart21 ENGINE = MyISAM,
23076
SUBPARTITION subpart22 ENGINE = MyISAM),
23077
PARTITION part3 VALUES LESS THAN (10)
23078
(SUBPARTITION subpart31 ENGINE = MyISAM,
23079
SUBPARTITION subpart32 ENGINE = MyISAM),
23080
PARTITION part4 VALUES LESS THAN (2147483646)
23081
(SUBPARTITION subpart41 ENGINE = MyISAM,
23082
SUBPARTITION subpart42 ENGINE = MyISAM)) */
22738
23084
unified filelist
22739
23085
t1#P#part1#SP#subpart11.MYD
23271
23617
`f_char2` char(20) DEFAULT NULL,
23272
23618
`f_charbig` varchar(1000) DEFAULT NULL,
23273
23619
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
23274
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
23620
) ENGINE=MyISAM DEFAULT CHARSET=latin1
23621
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
23622
SUBPARTITION BY HASH (f_int1 + 1)
23623
(PARTITION part1 VALUES IN (0)
23624
(SUBPARTITION sp11 ENGINE = MyISAM,
23625
SUBPARTITION sp12 ENGINE = MyISAM),
23626
PARTITION part2 VALUES IN (1)
23627
(SUBPARTITION sp21 ENGINE = MyISAM,
23628
SUBPARTITION sp22 ENGINE = MyISAM),
23629
PARTITION part3 VALUES IN (2)
23630
(SUBPARTITION sp31 ENGINE = MyISAM,
23631
SUBPARTITION sp32 ENGINE = MyISAM),
23632
PARTITION part4 VALUES IN (NULL)
23633
(SUBPARTITION sp41 ENGINE = MyISAM,
23634
SUBPARTITION sp42 ENGINE = MyISAM)) */
23276
23636
unified filelist
23277
23637
t1#P#part1#SP#sp11.MYD
23805
24165
`f_char2` char(20) DEFAULT NULL,
23806
24166
`f_charbig` varchar(1000) DEFAULT NULL,
23807
24167
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
23808
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
24168
) ENGINE=MyISAM DEFAULT CHARSET=latin1
24169
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
24170
SUBPARTITION BY KEY (f_int1)
24172
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
24173
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
24174
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
23810
24176
unified filelist
23811
24177
t1#P#part1#SP#part1sp0.MYD
24338
24704
`f_char2` char(20) DEFAULT NULL,
24339
24705
`f_charbig` varchar(1000) DEFAULT NULL,
24340
24706
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
24341
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1 + f_int2) PARTITIONS 2 */
24707
) ENGINE=MyISAM DEFAULT CHARSET=latin1
24708
/*!50100 PARTITION BY HASH (f_int1 + f_int2)
24343
24711
unified filelist
24856
25224
`f_char2` char(20) DEFAULT NULL,
24857
25225
`f_charbig` varchar(1000) DEFAULT NULL,
24858
25226
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
24859
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1,f_int2) PARTITIONS 5 */
25227
) ENGINE=MyISAM DEFAULT CHARSET=latin1
25228
/*!50100 PARTITION BY KEY (f_int1,f_int2)
24861
25231
unified filelist
25388
25758
`f_char2` char(20) DEFAULT NULL,
25389
25759
`f_charbig` varchar(1000) DEFAULT NULL,
25390
25760
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
25391
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
25761
) ENGINE=MyISAM DEFAULT CHARSET=latin1
25762
/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4))
25763
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
25764
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
25765
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
25766
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
25767
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
25768
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
25769
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
25770
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
25393
25772
unified filelist
25394
25773
t1#P#part0.MYD
25924
26303
`f_char2` char(20) DEFAULT NULL,
25925
26304
`f_charbig` varchar(1000) DEFAULT NULL,
25926
26305
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
25927
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
26306
) ENGINE=MyISAM DEFAULT CHARSET=latin1
26307
/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2)
26308
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
26309
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
26310
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
26311
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
26312
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
26313
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
25929
26315
unified filelist
25930
26316
t1#P#parta.MYD
26454
26840
`f_char2` char(20) DEFAULT NULL,
26455
26841
`f_charbig` varchar(1000) DEFAULT NULL,
26456
26842
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
26457
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int2) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
26843
) ENGINE=MyISAM DEFAULT CHARSET=latin1
26844
/*!50100 PARTITION BY RANGE (f_int1)
26845
SUBPARTITION BY HASH (f_int2)
26847
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
26848
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
26849
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
26850
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
26459
26852
unified filelist
26460
26853
t1#P#parta#SP#partasp0.MYD
26992
27385
`f_char2` char(20) DEFAULT NULL,
26993
27386
`f_charbig` varchar(1000) DEFAULT NULL,
26994
27387
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
26995
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int2) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
27388
) ENGINE=MyISAM DEFAULT CHARSET=latin1
27389
/*!50100 PARTITION BY RANGE (f_int1)
27390
SUBPARTITION BY KEY (f_int2)
27391
(PARTITION part1 VALUES LESS THAN (0)
27392
(SUBPARTITION subpart11 ENGINE = MyISAM,
27393
SUBPARTITION subpart12 ENGINE = MyISAM),
27394
PARTITION part2 VALUES LESS THAN (5)
27395
(SUBPARTITION subpart21 ENGINE = MyISAM,
27396
SUBPARTITION subpart22 ENGINE = MyISAM),
27397
PARTITION part3 VALUES LESS THAN (10)
27398
(SUBPARTITION subpart31 ENGINE = MyISAM,
27399
SUBPARTITION subpart32 ENGINE = MyISAM),
27400
PARTITION part4 VALUES LESS THAN (2147483646)
27401
(SUBPARTITION subpart41 ENGINE = MyISAM,
27402
SUBPARTITION subpart42 ENGINE = MyISAM)) */
26997
27404
unified filelist
26998
27405
t1#P#part1#SP#subpart11.MYD
27530
27937
`f_char2` char(20) DEFAULT NULL,
27531
27938
`f_charbig` varchar(1000) DEFAULT NULL,
27532
27939
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
27533
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int2 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
27940
) ENGINE=MyISAM DEFAULT CHARSET=latin1
27941
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
27942
SUBPARTITION BY HASH (f_int2 + 1)
27943
(PARTITION part1 VALUES IN (0)
27944
(SUBPARTITION sp11 ENGINE = MyISAM,
27945
SUBPARTITION sp12 ENGINE = MyISAM),
27946
PARTITION part2 VALUES IN (1)
27947
(SUBPARTITION sp21 ENGINE = MyISAM,
27948
SUBPARTITION sp22 ENGINE = MyISAM),
27949
PARTITION part3 VALUES IN (2)
27950
(SUBPARTITION sp31 ENGINE = MyISAM,
27951
SUBPARTITION sp32 ENGINE = MyISAM),
27952
PARTITION part4 VALUES IN (NULL)
27953
(SUBPARTITION sp41 ENGINE = MyISAM,
27954
SUBPARTITION sp42 ENGINE = MyISAM)) */
27535
27956
unified filelist
27536
27957
t1#P#part1#SP#sp11.MYD
28064
28485
`f_char2` char(20) DEFAULT NULL,
28065
28486
`f_charbig` varchar(1000) DEFAULT NULL,
28066
28487
UNIQUE KEY `uidx` (`f_int1`,`f_int2`)
28067
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int2) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
28488
) ENGINE=MyISAM DEFAULT CHARSET=latin1
28489
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
28490
SUBPARTITION BY KEY (f_int2)
28492
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
28493
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
28494
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
28069
28496
unified filelist
28070
28497
t1#P#part1#SP#part1sp0.MYD
28597
29024
`f_char2` char(20) DEFAULT NULL,
28598
29025
`f_charbig` varchar(1000) DEFAULT NULL,
28599
29026
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
28600
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) PARTITIONS 2 */
29027
) ENGINE=MyISAM DEFAULT CHARSET=latin1
29028
/*!50100 PARTITION BY HASH (f_int1)
28602
29031
unified filelist
29115
29544
`f_char2` char(20) DEFAULT NULL,
29116
29545
`f_charbig` varchar(1000) DEFAULT NULL,
29117
29546
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
29118
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) PARTITIONS 5 */
29547
) ENGINE=MyISAM DEFAULT CHARSET=latin1
29548
/*!50100 PARTITION BY KEY (f_int1)
29120
29551
unified filelist
29647
30078
`f_char2` char(20) DEFAULT NULL,
29648
30079
`f_charbig` varchar(1000) DEFAULT NULL,
29649
30080
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
29650
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
30081
) ENGINE=MyISAM DEFAULT CHARSET=latin1
30082
/*!50100 PARTITION BY LIST (MOD(f_int1,4))
30083
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
30084
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
30085
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
30086
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
30087
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
30088
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
30089
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
30090
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
29652
30092
unified filelist
29653
30093
t1#P#part0.MYD
30183
30623
`f_char2` char(20) DEFAULT NULL,
30184
30624
`f_charbig` varchar(1000) DEFAULT NULL,
30185
30625
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
30186
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
30626
) ENGINE=MyISAM DEFAULT CHARSET=latin1
30627
/*!50100 PARTITION BY RANGE (f_int1)
30628
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
30629
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
30630
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
30631
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
30632
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
30633
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
30188
30635
unified filelist
30189
30636
t1#P#parta.MYD
30713
31160
`f_char2` char(20) DEFAULT NULL,
30714
31161
`f_charbig` varchar(1000) DEFAULT NULL,
30715
31162
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
30716
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
31163
) ENGINE=MyISAM DEFAULT CHARSET=latin1
31164
/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
31165
SUBPARTITION BY HASH (f_int1)
31167
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
31168
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
31169
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
31170
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
30718
31172
unified filelist
30719
31173
t1#P#parta#SP#partasp0.MYD
31251
31705
`f_char2` char(20) DEFAULT NULL,
31252
31706
`f_charbig` varchar(1000) DEFAULT NULL,
31253
31707
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
31254
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
31708
) ENGINE=MyISAM DEFAULT CHARSET=latin1
31709
/*!50100 PARTITION BY RANGE (f_int1)
31710
SUBPARTITION BY KEY (f_int1)
31711
(PARTITION part1 VALUES LESS THAN (0)
31712
(SUBPARTITION subpart11 ENGINE = MyISAM,
31713
SUBPARTITION subpart12 ENGINE = MyISAM),
31714
PARTITION part2 VALUES LESS THAN (5)
31715
(SUBPARTITION subpart21 ENGINE = MyISAM,
31716
SUBPARTITION subpart22 ENGINE = MyISAM),
31717
PARTITION part3 VALUES LESS THAN (10)
31718
(SUBPARTITION subpart31 ENGINE = MyISAM,
31719
SUBPARTITION subpart32 ENGINE = MyISAM),
31720
PARTITION part4 VALUES LESS THAN (2147483646)
31721
(SUBPARTITION subpart41 ENGINE = MyISAM,
31722
SUBPARTITION subpart42 ENGINE = MyISAM)) */
31256
31724
unified filelist
31257
31725
t1#P#part1#SP#subpart11.MYD
31789
32257
`f_char2` char(20) DEFAULT NULL,
31790
32258
`f_charbig` varchar(1000) DEFAULT NULL,
31791
32259
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
31792
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
32260
) ENGINE=MyISAM DEFAULT CHARSET=latin1
32261
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
32262
SUBPARTITION BY HASH (f_int1 + 1)
32263
(PARTITION part1 VALUES IN (0)
32264
(SUBPARTITION sp11 ENGINE = MyISAM,
32265
SUBPARTITION sp12 ENGINE = MyISAM),
32266
PARTITION part2 VALUES IN (1)
32267
(SUBPARTITION sp21 ENGINE = MyISAM,
32268
SUBPARTITION sp22 ENGINE = MyISAM),
32269
PARTITION part3 VALUES IN (2)
32270
(SUBPARTITION sp31 ENGINE = MyISAM,
32271
SUBPARTITION sp32 ENGINE = MyISAM),
32272
PARTITION part4 VALUES IN (NULL)
32273
(SUBPARTITION sp41 ENGINE = MyISAM,
32274
SUBPARTITION sp42 ENGINE = MyISAM)) */
31794
32276
unified filelist
31795
32277
t1#P#part1#SP#sp11.MYD
32323
32805
`f_char2` char(20) DEFAULT NULL,
32324
32806
`f_charbig` varchar(1000) DEFAULT NULL,
32325
32807
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
32326
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
32808
) ENGINE=MyISAM DEFAULT CHARSET=latin1
32809
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
32810
SUBPARTITION BY KEY (f_int1)
32812
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
32813
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
32814
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
32328
32816
unified filelist
32329
32817
t1#P#part1#SP#part1sp0.MYD
32856
33344
`f_char2` char(20) DEFAULT NULL,
32857
33345
`f_charbig` varchar(1000) DEFAULT NULL,
32858
33346
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
32859
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1 + f_int2) PARTITIONS 2 */
33347
) ENGINE=MyISAM DEFAULT CHARSET=latin1
33348
/*!50100 PARTITION BY HASH (f_int1 + f_int2)
32861
33351
unified filelist
33374
33864
`f_char2` char(20) DEFAULT NULL,
33375
33865
`f_charbig` varchar(1000) DEFAULT NULL,
33376
33866
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
33377
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1,f_int2) PARTITIONS 5 */
33867
) ENGINE=MyISAM DEFAULT CHARSET=latin1
33868
/*!50100 PARTITION BY KEY (f_int1,f_int2)
33379
33871
unified filelist
33906
34398
`f_char2` char(20) DEFAULT NULL,
33907
34399
`f_charbig` varchar(1000) DEFAULT NULL,
33908
34400
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
33909
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) (PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, PARTITION part0 VALUES IN (0) ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) ENGINE = MyISAM, PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
34401
) ENGINE=MyISAM DEFAULT CHARSET=latin1
34402
/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4))
34403
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
34404
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
34405
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
34406
PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM,
34407
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
34408
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
34409
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
34410
PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
33911
34412
unified filelist
33912
34413
t1#P#part0.MYD
34442
34943
`f_char2` char(20) DEFAULT NULL,
34443
34944
`f_charbig` varchar(1000) DEFAULT NULL,
34444
34945
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
34445
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
34946
) ENGINE=MyISAM DEFAULT CHARSET=latin1
34947
/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2)
34948
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
34949
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
34950
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
34951
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
34952
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
34953
PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
34447
34955
unified filelist
34448
34956
t1#P#parta.MYD
34972
35480
`f_char2` char(20) DEFAULT NULL,
34973
35481
`f_charbig` varchar(1000) DEFAULT NULL,
34974
35482
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
34975
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int2) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
35483
) ENGINE=MyISAM DEFAULT CHARSET=latin1
35484
/*!50100 PARTITION BY RANGE (f_int1)
35485
SUBPARTITION BY HASH (f_int2)
35487
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
35488
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
35489
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
35490
PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
34977
35492
unified filelist
34978
35493
t1#P#parta#SP#partasp0.MYD
35510
36025
`f_char2` char(20) DEFAULT NULL,
35511
36026
`f_charbig` varchar(1000) DEFAULT NULL,
35512
36027
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
35513
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int2) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 ENGINE = MyISAM, SUBPARTITION subpart32 ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
36028
) ENGINE=MyISAM DEFAULT CHARSET=latin1
36029
/*!50100 PARTITION BY RANGE (f_int1)
36030
SUBPARTITION BY KEY (f_int2)
36031
(PARTITION part1 VALUES LESS THAN (0)
36032
(SUBPARTITION subpart11 ENGINE = MyISAM,
36033
SUBPARTITION subpart12 ENGINE = MyISAM),
36034
PARTITION part2 VALUES LESS THAN (5)
36035
(SUBPARTITION subpart21 ENGINE = MyISAM,
36036
SUBPARTITION subpart22 ENGINE = MyISAM),
36037
PARTITION part3 VALUES LESS THAN (10)
36038
(SUBPARTITION subpart31 ENGINE = MyISAM,
36039
SUBPARTITION subpart32 ENGINE = MyISAM),
36040
PARTITION part4 VALUES LESS THAN (2147483646)
36041
(SUBPARTITION subpart41 ENGINE = MyISAM,
36042
SUBPARTITION subpart42 ENGINE = MyISAM)) */
35515
36044
unified filelist
35516
36045
t1#P#part1#SP#subpart11.MYD
36048
36577
`f_char2` char(20) DEFAULT NULL,
36049
36578
`f_charbig` varchar(1000) DEFAULT NULL,
36050
36579
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
36051
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int2 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 ENGINE = MyISAM, SUBPARTITION sp12 ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 ENGINE = MyISAM, SUBPARTITION sp22 ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 ENGINE = MyISAM, SUBPARTITION sp32 ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 ENGINE = MyISAM, SUBPARTITION sp42 ENGINE = MyISAM)) */
36580
) ENGINE=MyISAM DEFAULT CHARSET=latin1
36581
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
36582
SUBPARTITION BY HASH (f_int2 + 1)
36583
(PARTITION part1 VALUES IN (0)
36584
(SUBPARTITION sp11 ENGINE = MyISAM,
36585
SUBPARTITION sp12 ENGINE = MyISAM),
36586
PARTITION part2 VALUES IN (1)
36587
(SUBPARTITION sp21 ENGINE = MyISAM,
36588
SUBPARTITION sp22 ENGINE = MyISAM),
36589
PARTITION part3 VALUES IN (2)
36590
(SUBPARTITION sp31 ENGINE = MyISAM,
36591
SUBPARTITION sp32 ENGINE = MyISAM),
36592
PARTITION part4 VALUES IN (NULL)
36593
(SUBPARTITION sp41 ENGINE = MyISAM,
36594
SUBPARTITION sp42 ENGINE = MyISAM)) */
36053
36596
unified filelist
36054
36597
t1#P#part1#SP#sp11.MYD
36582
37125
`f_char2` char(20) DEFAULT NULL,
36583
37126
`f_charbig` varchar(1000) DEFAULT NULL,
36584
37127
UNIQUE KEY `uidx` (`f_int2`,`f_int1`)
36585
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int2) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) ENGINE = MyISAM, PARTITION part2 VALUES IN (1) ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
37128
) ENGINE=MyISAM DEFAULT CHARSET=latin1
37129
/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
37130
SUBPARTITION BY KEY (f_int2)
37132
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
37133
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
37134
PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
36587
37136
unified filelist
36588
37137
t1#P#part1#SP#part1sp0.MYD