The DB is small <2GB. I was resizing the server it runs on - we went from 2 to 4 cpus, 4 to 8 GB of memory ... I'm doing some silly things with a few queries and it's CPU intensive to query for the front page. Going to improve those queries but it'll be nice to have a performance buffer if I do something silly again.

May I ask how big the db is already? I imagine it is still okay because it's mostly varchar instead of images or video. 

tomlaies

That was some gnarly downtime. Yikes ... have to work on that.

k00b

247bf84fda

Daily discussion thread

saloon

Three tasks today:
1. resizing the db
2. trying to optimize query performance
3. tuning WoT