sas和ssd盘写入数据效率对比 - 风的_理想

时间:2024-02-15 15:22:27

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

下面为各磁盘性能指标对比图: