MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
partition_alter4.inc
1 ################################################################################
2 # inc/partition_alter1.inc #
3 # #
4 # Purpose: #
5 # Execute ALTER ... OPTIMIZE/CHECK/REBUID/ANALYZE statements (maintenance) #
6 # #
7 #------------------------------------------------------------------------------#
8 # Original Author: HH #
9 # Original Date: 2006-07-27 #
10 # Change Author: #
11 # Change Date: #
12 # Change: #
13 ################################################################################
14 
15 --echo
16 --echo #========================================================================
17 --echo # 1.1.1.12 ALTER TABLE <maintenance> PARTITION
18 --echo #========================================================================
19 --echo #------------------------------------------------------------------------
20 --echo # 1 ALTER ... ANALYZE PARTITION
21 --echo #------------------------------------------------------------------------
22 --echo # 1.1 ALTER ... ANALYZE PARTITION part_1;
23 let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1;
24 --source suite/parts/inc/partition_alter_41.inc
25 --echo # 1.2 ALTER ... ANALYZE PARTITION part_1,part_2;
26 let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1,part_2;
27 --source suite/parts/inc/partition_alter_41.inc
28 --echo # 1.3 ALTER ... ANALYZE PARTITION part_1,part_2,part_5,part_6,part_10;
29 let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1,part_2,part_5,part_6,part_10;
30 --source suite/parts/inc/partition_alter_41.inc
31 --echo # 1.4 ALTER ... ANALYZE PARTITION part_1,part_1,part_1;
32 let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1,part_1,part_1;
33 --source suite/parts/inc/partition_alter_41.inc
34 --echo # 1.5 ALTER ... ANALYZE PARTITION ALL;
35 let $alter= ALTER TABLE t1 ANALYZE PARTITION ALL;
36 --source suite/parts/inc/partition_alter_41.inc
37 
38 --echo #------------------------------------------------------------------------
39 --echo # 2 ALTER ... CHECK PARTITION
40 --echo #------------------------------------------------------------------------
41 --echo # 2.1 ALTER ... CHECK PARTITION part_1;
42 let $alter= ALTER TABLE t1 CHECK PARTITION part_1;
43 --source suite/parts/inc/partition_alter_41.inc
44 --echo # 2.2 ALTER ... CHECK PARTITION part_1,part_2;
45 let $alter= ALTER TABLE t1 CHECK PARTITION part_1,part_2;
46 --source suite/parts/inc/partition_alter_41.inc
47 --echo # 2.3 ALTER ... CHECK PARTITION part_1,part_2,part_5,part_6,part_10;
48 let $alter= ALTER TABLE t1 CHECK PARTITION part_1,part_2,part_5,part_6,part_10;
49 --source suite/parts/inc/partition_alter_41.inc
50 --echo # 2.4 ALTER ... CHECK PARTITION part_1,part_1,part_1;
51 let $alter= ALTER TABLE t1 CHECK PARTITION part_1,part_1,part_1;
52 --source suite/parts/inc/partition_alter_41.inc
53 --echo # 2.5 ALTER ... CHECK PARTITION ALL;
54 let $alter= ALTER TABLE t1 CHECK PARTITION ALL;
55 --source suite/parts/inc/partition_alter_41.inc
56 
57 --echo #------------------------------------------------------------------------
58 --echo # 3 ALTER ... OPTIMIZE PARTITION
59 --echo #------------------------------------------------------------------------
60 --echo # 3.1 ALTER ... OPTIMIZE PARTITION part_1;
61 let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1;
62 --source suite/parts/inc/partition_alter_41.inc
63 --echo # 3.2 ALTER ... OPTIMIZE PARTITION part_1,part_2;
64 let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1,part_2;
65 --source suite/parts/inc/partition_alter_41.inc
66 --echo # 3.3 ALTER ... OPTIMIZE PARTITION part_1,part_2,part_5,part_6,part_10;
67 let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1,part_2,part_5,part_6,part_10;
68 --source suite/parts/inc/partition_alter_41.inc
69 --echo # 3.4 ALTER ... OPTIMIZE PARTITION part_1,part_1,part_1;
70 let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1,part_1,part_1;
71 --source suite/parts/inc/partition_alter_41.inc
72 --echo # 3.5 ALTER ... OPTIMIZE PARTITION ALL;
73 let $alter= ALTER TABLE t1 OPTIMIZE PARTITION ALL;
74 --source suite/parts/inc/partition_alter_41.inc
75 
76 --echo #------------------------------------------------------------------------
77 --echo # 4 ALTER ... REBUILD PARTITION
78 --echo #------------------------------------------------------------------------
79 --echo # 4.1 ALTER ... REBUILD PARTITION part_1;
80 let $alter= ALTER TABLE t1 REBUILD PARTITION part_1;
81 --source suite/parts/inc/partition_alter_41.inc
82 --echo # 4.2 ALTER ... REBUILD PARTITION part_1,part_2;
83 let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_2;
84 --source suite/parts/inc/partition_alter_41.inc
85 --echo # 4.3 ALTER ... REBUILD PARTITION part_1,part_2,part_5,part_6,part_10;
86 let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_2,part_5,part_6,part_10;
87 --source suite/parts/inc/partition_alter_41.inc
88 --echo # 4.4 ALTER ... REBUILD PARTITION part_1,part_1,part_1;
89 let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_1,part_1;
90 --source suite/parts/inc/partition_alter_41.inc
91 --echo # 4.5 ALTER ... REBUILD PARTITION ALL;
92 let $alter= ALTER TABLE t1 REBUILD PARTITION ALL;
93 --source suite/parts/inc/partition_alter_41.inc
94 
95 --echo #------------------------------------------------------------------------
96 --echo # 5 ALTER ... REPAIR PARTITION
97 --echo #------------------------------------------------------------------------
98 --echo # 5.1 ALTER ... REPAIR PARTITION part_1;
99 let $alter= ALTER TABLE t1 REPAIR PARTITION part_1;
100 --source suite/parts/inc/partition_alter_41.inc
101 --echo # 5.2 ALTER ... REPAIR PARTITION part_1,part_2;
102 let $alter= ALTER TABLE t1 REPAIR PARTITION part_1,part_2;
103 --source suite/parts/inc/partition_alter_41.inc
104 --echo # 5.3 ALTER ... REPAIR PARTITION part_1,part_2,part_5,part_6,part_10;
105 let $alter= ALTER TABLE t1 REPAIR PARTITION part_1,part_2,part_5,part_6,part_10;
106 --source suite/parts/inc/partition_alter_41.inc
107 --echo # 5.4 ALTER ... REPAIR PARTITION part_1,part_1,part_1;
108 let $alter= ALTER TABLE t1 REPAIR PARTITION part_1,part_1,part_1;
109 --source suite/parts/inc/partition_alter_41.inc
110 --echo # 5.5 ALTER ... REPAIR PARTITION ALL;
111 let $alter= ALTER TABLE t1 REPAIR PARTITION ALL;
112 --source suite/parts/inc/partition_alter_41.inc
113 
114 --echo #------------------------------------------------------------------------
115 --echo # 6 ALTER ... REMOVE PARTITIONING
116 --echo #------------------------------------------------------------------------
117 --echo # 6.1 ALTER ... REMOVE PARTITIONING;
118 let $alter= ALTER TABLE t1 REMOVE PARTITIONING;
119 --source suite/parts/inc/partition_alter_41.inc
120