Technical details:
- In the shoutbox table, changed columns of type int that only ever used two values to bit type and updated queries accordingly.
- Created a more effective concatenated index used by shoutbox queries.
- Changed queries on the shoutbox table that ordered by time (which wasn't indexed for some reason) to use the primary key instead, since the id and time are monotonically increasing.
EDIT: To give credit where it's due, shout out to Ashamed for some advice and motivation.
EDIT 2: For a sense of scale, on a four-hour uptime, shoutbox refresh requests made up just over 27.99% of requests to the site according to the access logs.
Post has been edited 3 time(s), last time on May 10 2017, 2:36 am by Mini Moose 2707.
https://www.collaborativefund.com/blog/how-this-all-happened/
https://thelastpsychiatrist.com/2012/11/hipsters_on_food_stamps.html
https://youtu.be/vyiXaCRwZTs
https://thelastpsychiatrist.com/2011/09/how_to_be_mean_to_your_kids.html
http://lab.cccb.org/en/renata-avila-the-internet-of-creation-disappeared-now-we-have-the-internet-of-surveillance-and-control/
https://thelastpsychiatrist.com/2012/11/hipsters_on_food_stamps.html
https://youtu.be/vyiXaCRwZTs
https://thelastpsychiatrist.com/2011/09/how_to_be_mean_to_your_kids.html
http://lab.cccb.org/en/renata-avila-the-internet-of-creation-disappeared-now-we-have-the-internet-of-surveillance-and-control/