Site is struggling as an upgrade to MySQL 5.6 seems to have made some previously fast queries very slow. Struggling along with site.
-
-
Replying to @Pinboard
Shot in the dark from a noob: Set innodb_buffer_pool_instances to ~ 8, consistent with innodb_buffer_pool_size advice.pic.twitter.com/qIoAmCnWzt
1 reply 1 retweet 7 likes -
Replying to @crankycatcoder
is this something that changed from 5.5 to 5.6?
2 replies 0 retweets 0 likes -
Replying to @Pinboard
IIRC buffer pool algo changed. But I was at a different job a while ago and don't have access to what we did.
1 reply 0 retweets 0 likes
Replying to @crankycatcoder
thanks, despite poking fun I appreciate it and will take a look. At first blush, I think it’s query optimization at fault
10:37 AM - 3 Jul 2017
0 replies
0 retweets
3 likes
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.