If someone thinks the easiest thing to do is just try to upgrade to MariadB 10.x, I'm game to give that a go. I'm just wondering if anyone has any clue where to go from here? I have tried some of the suggestions like the ones posted here without any luck. I have tried setting the remote my.cnf file up to be nearly identical to my local server, but running SHOW VARIABLES there is a pretty big difference, and I really would rather not go through the differences (shown below) line-by-line. Let's just say it's a very large select query with a ton of left and inner joins (see below). I know this because I exported the remote database, then imported it locally, and the problem goes away. I'm having this lock wait timeout exceeded issue with a MariadB (version 5.5.56) on a remote server that I'm not having on a local MySQL (version 5.5.57) instance. Edit #2: I have now tried two MariaDB databases, one MySQL, and one Percona, and only the MariaDB instances are locking.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |