Problem: Some WordPress plugin cause a lot of long-running queries and seems to want to run forever:( (You can check it out by entering SQL command “show processlist;”)
Solution: Set up session-wide or global timeout:
For MySQL, enter below command
SET SESSION MAX_EXECUTION_TIME=2000; SET GLOBAL MAX_EXECUTION_TIME=2000;
For MariaDB, enter below command:
SET SESSION max_statement_time=2000; SET GLOBAL max_statement_time=2000;
2000 is 2000 second.