关于innodb和tokudb存储引擎的压缩能力测试

MySQL存储引擎性能压测

一、表结构：

 

CREATE TABLE `huayu_tokudb` (

  `waybill_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '?????',

  `waybill_no` varchar(20) NOT NULL COMMENT '???',

  `post_date` datetime NOT NULL COMMENT '????????',

  `order_id` varchar(50) DEFAULT NULL COMMENT '?????????',

  `batch_no` varchar(50) DEFAULT NULL COMMENT '???',

  `biz_product_id` varchar(20) NOT NULL COMMENT '??????',

  `biz_product_no` varchar(20) NOT NULL COMMENT '??????',

  `biz_product_name` varchar(50) NOT NULL COMMENT '??????',

  `sender_type` varchar(20) DEFAULT NULL COMMENT '0 ?? 1????',

  `sender_id` varchar(50) DEFAULT NULL COMMENT '??????',

  `sender_no` varchar(50) DEFAULT NULL COMMENT '??????(??????)',

  `sender` varchar(200) DEFAULT NULL COMMENT '??????',

  `sender_linker` varchar(200) DEFAULT NULL,

  `sender_fixtel` varchar(50) DEFAULT NULL COMMENT '??????',

  `sender_mobile` varchar(50) DEFAULT NULL COMMENT '??????',

  `sender_addr` varchar(200) DEFAULT NULL COMMENT '??????',

  `sender_country_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `sender_country_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `sender_province_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `sender_province_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `sender_city_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `sender_city_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `sender_county_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `sender_county_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `sender_notes` varchar(1000) DEFAULT NULL COMMENT '????',

  `receiver_no` varchar(50) DEFAULT NULL COMMENT '??????????????',

  `receiver` varchar(200) DEFAULT NULL COMMENT '??????',

  `receiver_linker` varchar(200) DEFAULT NULL,

  `receiver_fixtel` varchar(50) DEFAULT NULL COMMENT '??????',

  `receiver_mobile` varchar(50) DEFAULT NULL COMMENT '??????',

  `receiver_addr` varchar(200) DEFAULT NULL COMMENT '??????',

  `receiver_country_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `receiver_country_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `receiver_province_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `receiver_province_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `receiver_city_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `receiver_city_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `receiver_county_no` varchar(20) DEFAULT NULL COMMENT '??????',

  `receiver_county_name` varchar(50) DEFAULT NULL COMMENT '??????',

  `insurance_flag` char(1) DEFAULT NULL COMMENT '????????????1:?? 2:?? 3:??',

  `insurance_amount` decimal(12,2) DEFAULT NULL COMMENT '??????',

  `pickup_type` varchar(20) DEFAULT NULL COMMENT '?????0 ???????1 ??????',

  `payment_mode` varchar(20) DEFAULT NULL COMMENT '????(???) 1:??? 2:??? 3:??? 4:??????? 5:?? 6:?/??? 7:???',

  `real_weight` decimal(8,0) DEFAULT NULL COMMENT '????',

  `fee_weight` decimal(8,0) DEFAULT NULL,

  `volume_weight` decimal(8,0) DEFAULT NULL,

  `length` decimal(8,0) DEFAULT NULL,

  `width` decimal(8,0) DEFAULT NULL,

  `height` decimal(8,0) DEFAULT NULL,

  `quantity` int(11) DEFAULT NULL,

  `packaging` varchar(20) DEFAULT NULL,