The site is struggling right now (technical reason seems to be a NUMA issue with mysql memory allocation, if anyone knows articles more recent than https://blog.jcole.us/2012/04/16/a-brief-update-on-numa-and-mysql/ … on dealing with this, I'm all ears).
-
Show this thread
-
I found the innodb_numa_interleave parameter and will monkey with it at a less busy time. Server was swapping up a storm despite only using half of memory; I fixed things for the time being by reducing the database memory allocation. This is why you should never upgrade anything
1 reply 0 retweets 32 likesShow this thread -
Replying to @Pinboard
That article is still relevant if you’re using MySQL 5.7/8.0. If you need any further help, don’t hesitate to DM
1 reply 0 retweets 1 like -
Replying to @bytebot
Thank you! It's very helpful to know that it's not out of date. I'm actually on 5.6!
1 reply 0 retweets 0 likes -
Replying to @Pinboard
as long as you're running 5.6.27 and greater, you have that option and are good to go!
1 reply 0 retweets 2 likes
I'm on 5.6.44 — thanks for the good news!
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.