Hi everyone,
for a little while now (not sure if it started after the 3.3.10 update) I noticed moments where my website is simply not loading for several minutes. It took me a while to realize that it comes from the database and what I suspect is a deadlock situation. This makes it of course difficult to track down as you need to be present when it happens. So a moment ago the problem occurred again and I rushed to the phpmyadmin to have a look at the db (mariadb). Unfortunately not a lot can be seen.
Any tips on how to better get to the bottom of this. I tried killing the processes in the hope to resolve the deadlock but ended up restarting the service altogether. If I leave it, the situation will resolve on its own, guess maria will recognize the deadlock at some point and kill the processes itself.
I was hoping to see the statements but unfortunately no luck.
Thanks in advance!