Re: mariadb locks

Posted by ErmanArslansOracleBlog on Oct 08, 2023; 8:27am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/mariadb-locks-tp12077p12092.html

I m not an expert in Mariadb but once you got Oracle , those types of databases are easy to deal with. That's why, I may recommend you some actions ->

Set the following parameter and then check with that deadlock reporting command-> innodb_print_all_deadlocks = ON

If those deadlocks are appearing again and again, no  matter what.. Then your app is the cause. You should consider changing the behavior of the app which causes this deadlock.