memory引擎和innodb引擎速度对比
ysql> insert into innodb_test (name) select name from innodb_test; Query OK, 1048576 rows affected (1 min 9.47 sec) Records: 1048576 Duplicates: 0 Warnings: 0
mysql> insert into memory_test (name) select name from memory_test; Query OK, 1048576 rows affected (6.45 sec) Records: 1048576 Duplicates: 0 Warnings: 0
10倍的速度差距
MySQL限时解答,24小时内友哥专业解答
http://www.yougemysqldba.com
如有进一步需要请联系微信onesoft007
微博账号@友哥一指
http://www.yougemysqldba.com
如有进一步需要请联系微信onesoft007
微博账号@友哥一指