innodb_rollback_on_timeout：默认是off,当为off时，事务如果超时，只会回滚最后条sql 当为on时会回滚事务的所有sql
innodb_lock_wait_timeout: 事务超时时间默认是50s，可以改大点
查询事务相关的sql:
select * from information_schema.INNODB_TRX;
select * from information_schema.INNODB_LOCKS;
select * from information_schema.INNODB_LOCK_WAITS;
查询变量相关：
show VARIABLES like "innodb_lock_wait_timeout"
标签：information,transaction,Lock,INNODB,timeout,exceeded,schema,select,wait From： https://www.cnblogs.com/yangxiaohui227/p/17198535.html