13
13
create table t1 (a int) engine=innodb partition by hash(a) ;
14
14
show table status like 't1';
15
15
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
16
t1 InnoDB 10 Compact 2 8192 16384 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL partitioned
16
t1 InnoDB 10 Compact 2 8192 16384 0 0 <datafree> NULL NULL NULL NULL latin1_swedish_ci NULL partitioned
18
18
create table t1 (a int)
20
20
partition by key (a);
22
22
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
23
t1 InnoDB 10 Compact 2 8192 16384 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL partitioned
23
t1 InnoDB 10 Compact 2 8192 16384 0 0 <datafree> NULL NULL NULL NULL latin1_swedish_ci NULL partitioned
24
24
insert into t1 values (0), (1), (2), (3);
26
26
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
27
t1 InnoDB 10 Compact 4 4096 16384 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL partitioned
27
t1 InnoDB 10 Compact 4 4096 16384 0 0 <datafree> NULL NULL NULL NULL latin1_swedish_ci NULL partitioned
29
29
create table t1 (a int auto_increment primary key)
31
31
partition by key (a);
33
33
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
34
t1 InnoDB 10 Compact 2 8192 16384 0 0 0 1 NULL NULL NULL latin1_swedish_ci NULL partitioned
35
insert into t1 values (NULL), (NULL), (NULL), (NULL);
37
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
38
t1 InnoDB 10 Compact 4 4096 16384 0 0 0 5 NULL NULL NULL latin1_swedish_ci NULL partitioned
39
insert into t1 values (NULL), (NULL), (NULL), (NULL);
41
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
42
t1 InnoDB 10 Compact 8 2048 16384 0 0 0 9 NULL NULL NULL latin1_swedish_ci NULL partitioned
34
t1 InnoDB 10 Compact 2 8192 16384 0 0 <datafree> 1 NULL NULL NULL latin1_swedish_ci NULL partitioned
35
insert into t1 values (NULL), (NULL), (NULL), (NULL);
37
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
38
t1 InnoDB 10 Compact 4 4096 16384 0 0 <datafree> 5 NULL NULL NULL latin1_swedish_ci NULL partitioned
39
insert into t1 values (NULL), (NULL), (NULL), (NULL);
41
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
42
t1 InnoDB 10 Compact 8 2048 16384 0 0 <datafree> 9 NULL NULL NULL latin1_swedish_ci NULL partitioned
44
44
create table t1 (a int)
45
45
partition by key (a)