sas和ssd盘写入数据效率对比
表结构如下:
CREATE TABLE `tab_AAA` (
`id` bigint(20) NOT NULL AUTO_INCREMENT ,
`customer_no` varchar(32) NOT NULL DEFAULT \'\' \',
`agreement_type` varchar(10) NOT NULL DEFAULT \'\' ,
`agreement_version` varchar(10) NOT NULL DEFAULT \'\' \',
`agreement_status` varchar(8) NOT NULL DEFAULT \'\' ,
`sign_time` datetime DEFAULT \'1970-01-01 00:00:00\',
`dissign_time` datetime DEFAULT NULL,
`end_date` date DEFAULT NULL,
`create_time` datetime NOT NULL DEFAULT \'1970-01-01 00:00:00\',
`create_by` varchar(20) NOT NULL DEFAULT \'system\',
`update_time` datetime NOT NULL DEFAULT \'1970-01-01 00:00:00\' ,
`update_by` varchar(20) NOT NULL DEFAULT \'system\',
`entity_type` varchar(32) DEFAULT NULL \',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=547187 DEFAULT CHARSET=utf8;
数据量为:54万
分别使用create table Tab_BBB as select * from tab_AAA建表:
sas盘:15.46S
ssd盘:2.84S
下面为各磁盘性能指标对比图: