mysql預存程序對900w資料進行操作測試

標籤：

新增索引：
LTER TABLE `tablename` ADD INDEX `sdhid` (`createTime`) USING BTREE ;
[SQL]ALTER TABLE `tablename` ADD INDEX `sdhid` (`createTime`) USING BTREE ;
受影響的行: 0
時間: 737.600s

[SQL]ALTER TABLE  tablename add INDEX jkjk(createTime) USING BTREE;
受影響的行: 0
時間: 1586.745s 26分鐘

[SQL]delete from tablename where createTime< 95 limit 1;
受影響的行: 0
時間: 109.540s

createTime有索引時刪除測試：
[SQL]ALTER TABLE  tablename add INDEX jkjk(createTime) USING BTREE;
受影響的行: 0
時間: 1586.745s 26分鐘

[SQL]delete from tablename where createTime< 95 limit 1;
受影響的行: 0
時間: 109.540s

[SQL] delete from tablename where createTime< 95 order by createTime,id limit 1;
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction

[SQL] delete from tablename where createTime< 95 order by createTime,id limit 1;
受影響的行: 0
時間: 185.007s

[SQL]delete from tablename where createTime< 95 order by createTime limit 1;
受影響的行: 0
時間: 169.260s

[SQL]delete from tablename where createTime< 95 limit 1;
受影響的行: 0
時間: 153.959s

createTime無索引時刪除測試：
[SQL]delete from tablename where createTime< 95 limit 1;
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction

[SQL]delete from tablename where createTime< 95 limit 1;
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction

[SQL] delete from tablename where createTime< 95 order by createTime,id limit 1;
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction

[SQL]delete from tablename where createTime< 95 limit 1;
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction

[SQL]delete from tablename where createTime< 95 limit 1;
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction

[SQL]delete from tablename where createTime< 95 limit 1;
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction


多多指教呀，什麼

mysql預存程序對900w資料進行操作測試