| 1 |
CREATE TABLE `t` ( |
| 2 |
`col_1` varchar(255) NOT NULL DEFAULT '', |
| 3 |
`col_2` varchar(255) NOT NULL, |
| 4 |
`col_3` int(11) NOT NULL DEFAULT '0', |
| 5 |
`col_4` int(11) NOT NULL DEFAULT '0' |
| 6 |
) ENGINE=Aria TRANSACTIONAL=0 PAGE_CHECKSUM=0; |
| 7 |
insert into t values |
| 8 |
('foobar','qux',0,0),('abcdef','qux',0,0); |
| 9 |
Compressing test/t.MAD: (2 records) |
| 10 |
- Calculating statistics |
| 11 |
|
| 12 |
normal: 0 empty-space: 0 empty-zero: 0 empty-fill: 0 |
| 13 |
pre-space: 0 end-space: 0 intervall-fields: 0 zero: 2 |
| 14 |
Original trees: 4 After join: 1 |
| 15 |
- Compressing file |
| 16 |
Min record length: 5 Max length: 5 Mean total length: 35 |
| 17 |
99.57% |
| 18 |
# restart |
| 19 |
SELECT * FROM t; |
| 20 |
col_1 col_2 col_3 col_4 |
| 21 |
foobar qux 0 0 |
| 22 |
abcdef qux 0 0 |
| 23 |
DROP TABLE t; |