Difficulties in using MySQL Databases

The following articles mainly introduce the actual solutions for errors encountered when using the MySQL database, and the correct modification solutions for errors encountered when using the MySQL database, the following is a description of the specific solution, hoping to help you in this regard.

When using the MySQL database, you may encounter some errors:

 
 


  
  
Error Msg:

  
  
Lock wait timeout exceeded; try restarting transaction

 
 

Modification method:

I don't know if MySQL can set timeout Based on Session. However, you can set the global engine timeout.

Set in my. ini or my. cnf (linux)
 

 
 


  
  
Innodb_lock_wait_timeout = 600

 
 

The above content is an introduction to solutions that encounter errors when using the MySQL database. I hope you will find some gains.