MySQL stored procedures to perform operational tests on 900w data

New index:
Lter TABLE ' tablename ' ADD INDEX ' sdhid ' (' createtime ') USING BTREE;
[SQL] ALTER TABLE ' tablename ' ADD INDEX ' sdhid ' (' createtime ') USING BTREE;
Rows affected: 0
Time: 737.600s

[SQL] ALTER TABLE tablename Add INDEX jkjk (createtime) USING BTREE;
Rows affected: 0
Duration: 1586.745s 26 minutes

[Sql]delete from TableName where createtime<-Limit 1;
Rows affected: 0
Time: 109.540s

Createtime Delete Test when index is indexed:
[SQL] ALTER TABLE tablename Add INDEX jkjk (createtime) USING BTREE;
Rows affected: 0
Duration: 1586.745s 26 minutes

[Sql]delete from TableName where createtime<-Limit 1;
Rows affected: 0
Time: 109.540s

[SQL] Delete from tablename where createtime< the order by Createtime,id limit 1;
[ERR] 1205-lock wait timeout exceeded; Try restarting transaction

[SQL] Delete from tablename where createtime< the order by Createtime,id limit 1;
Rows affected: 0
Time: 185.007s

[Sql]delete from TableName where createtime<-up order by createtime limit 1;
Rows affected: 0
Time: 169.260s

[Sql]delete from TableName where createtime<-Limit 1;
Rows affected: 0
Time: 153.959s

Createtime Delete Test without index:
[Sql]delete from TableName where createtime<-Limit 1;
[ERR] 1205-lock wait timeout exceeded; Try restarting transaction

[Sql]delete from TableName where createtime<-Limit 1;
[ERR] 1205-lock wait timeout exceeded; Try restarting transaction

[SQL] Delete from tablename where createtime< the order by Createtime,id limit 1;
[ERR] 1205-lock wait timeout exceeded; Try restarting transaction

[Sql]delete from TableName where createtime<-Limit 1;
[ERR] 1205-lock wait timeout exceeded; Try restarting transaction

[Sql]delete from TableName where createtime<-Limit 1;
[ERR] 1205-lock wait timeout exceeded; Try restarting transaction

[Sql]delete from TableName where createtime<-Limit 1;
[ERR] 1205-lock wait timeout exceeded; Try restarting transaction


More advice, what

MySQL stored procedures to perform operational tests on 900w data