not sure how to debug this, its a large wordpress site with a big database and showprocesslist isn’t giving me many clues, how do i set up a slowquery log on mariadb via ssh/phpmyadmin? and are the some basic mysql settings i can change that may resolve it?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.