|
mysql> show table status;
----------
| 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 |
----------
| customer |
Columnstore |
10 |
Dynamic |
2000 |
0 |
0 |
0 |
0 |
0 |
NULL |
NULL |
NULL |
NULL |
latin1_swedish_ci |
NULL |
|
|
| dim_date |
Columnstore |
10 |
Fixed |
2000 |
0 |
0 |
0 |
0 |
0 |
NULL |
NULL |
NULL |
NULL |
latin1_swedish_ci |
NULL |
|
|
| lineorder |
Columnstore |
10 |
Dynamic |
2000 |
0 |
0 |
0 |
0 |
0 |
NULL |
NULL |
NULL |
NULL |
latin1_swedish_ci |
NULL |
|
|
| part |
Columnstore |
10 |
Dynamic |
2000 |
0 |
0 |
0 |
0 |
0 |
NULL |
NULL |
NULL |
NULL |
latin1_swedish_ci |
NULL |
|
|
| supplier |
Columnstore |
10 |
Dynamic |
2000 |
0 |
0 |
0 |
0 |
0 |
NULL |
NULL |
NULL |
NULL |
latin1_swedish_ci |
NULL |
|
|
----------
All tables have rows set to 2000, 0 for all other fields. For some reason dim_date shows as type 'fixed' while other tables are 'Dynamic'
|