《MYSQL教程MySQL兩種表存儲結(jié)構(gòu)MyISAM和InnoDB的性能比較測試》要點(diǎn)：
本文介紹了MYSQL教程MySQL兩種表存儲結(jié)構(gòu)MyISAM和InnoDB的性能比較測試，希望對您有用。如果有疑問，可以聯(lián)系我們。

MyISAM_NT?? 04-10-22 16:33:24
04-10-22 16:33:26
MyISAM_NT count: 10000? used time: 2.1132440567
MyISAM_TS?? 04-10-22 16:33:26
ExecSQL:BEGIN;
ExecSQL:COMMIT;
04-10-22 16:33:29
MyISAM_TS count: 10000? used time: 2.65475201607
INNODB_NA_NB?? 04-10-22 16:33:29
ExecSQL:Set AUTOCOMMIT = 0
04-10-22 16:33:31
INNODB_NA_NB count: 10000? used time: 2.51947999001
INNODB_NA_BE?? 04-10-22 16:33:31
ExecSQL:Set AUTOCOMMIT = 0
ExecSQL:BEGIN;
ExecSQL:COMMIT;
04-10-22 16:33:35
INNODB_NA_BE count: 10000? used time: 3.85625100136
INNODB_AU_NB?? 04-10-22 16:33:35
ExecSQL:Set AUTOCOMMIT = 1
04-10-22 16:34:19
INNODB_AU_NB count: 10000? used time: 43.7153041363
INNODB_AU_BE?? 04-10-22 16:34:19
ExecSQL:Set AUTOCOMMIT = 1
ExecSQL:BEGIN;
ExecSQL:COMMIT;
04-10-22 16:34:22
INNODB_AU_BE count: 10000? used time: 3.14328193665
結(jié)論：
由此得知影響速度的主要原因是AUTOCOMMIT默認(rèn)設(shè)置是打開的,
我當(dāng)時(shí)的程序沒有顯式調(diào)用BEGIN;開始事務(wù),導(dǎo)致每插入一條都自動Commit,嚴(yán)重影響了速度.
算來也是個(gè)低級錯(cuò)誤!

歡迎參與《MYSQL教程MySQL兩種表存儲結(jié)構(gòu)MyISAM和InnoDB的性能比較測試》討論，分享您的想法，維易PHP學(xué)院為您提供專業(yè)教程。

轉(zhuǎn)載請注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/12665.html