02-02-2024, 08:23 PM
This is what we are looking for:
SHOW FULL PROCESSLIST;
https://serverfault.com/questions/36260/how-can-i-show-mysql-locks
https://www.dbrnd.com/2016/02/mysql-script-to-identify-the-locks-and-blocking-transactions/
https://dba.stackexchange.com/questions/260543/identifying-blocking-queries-on-mysql-5-5
https://sql-developers.co.uk/mysql-tutorial/finding-mysql-blocking-queries-and-deadlocks.html
see if you can share some of that information here, see if I can help
SHOW FULL PROCESSLIST;
https://serverfault.com/questions/36260/how-can-i-show-mysql-locks
https://www.dbrnd.com/2016/02/mysql-script-to-identify-the-locks-and-blocking-transactions/
https://dba.stackexchange.com/questions/260543/identifying-blocking-queries-on-mysql-5-5
https://sql-developers.co.uk/mysql-tutorial/finding-mysql-blocking-queries-and-deadlocks.html
see if you can share some of that information here, see if I can help
Joe
TSolucio
TSolucio