1
Aldar
3y

Boy, I sure do love trying to figure out why our master and slave MariaDBs differ in their execution plans, even after running analyze tables on the whole DB.

Or rather, I really hope the two boxes didn't somehow magically desynced, cuz that would then beg a question of why, and how to prevent that from happening again.

I hate how databases are so necessary nowadays, but are probably the most complex and black box software I deal with. There's just so much to consider...

Comments
  • 0
    Okay, TIL that table statistics are made out of just a few memory pages, the number of which can be changed.

    Doubling it changed the statistics so much the plans finally synced up :3
Add Comment