mysql insert time

来源:互联网 发布:阿里云可用区什么意思 编辑:程序博客网 时间:2024/06/06 00:17

MyISAM
[SQL]insert into test SELECT * from test;
受影响的行: 524288
时间: 202.858s

[SQL]insert into test SELECT * from test;
受影响的行: 1048576
时间: 500.456s


InnoDB
[SQL]insert into test SELECT * from test;
受影响的行: 131072
时间: 6.196s

[SQL]insert into test SELECT * from test;
受影响的行: 262144
时间: 36.538s

[SQL]insert into test SELECT * from test;
受影响的行: 524288
时间: 103.704s

[SQL]insert into test SELECT * from test;
受影响的行: 1048576
时间: 505.698s

 

[SQL]insert into test SELECT * from test;
受影响的行: 1048576
时间: 505.698s

[SQL]insert into test SELECT * from test;

受影响的行: 2097152
时间: 1072.202s

0 0
原创粉丝点击