21 sats \ 3 replies \ @k00b 2 Apr 2022 \ on: Daily discussion thread
Three tasks today:
  1. resizing the db
  2. trying to optimize query performance
  3. tuning WoT
write
preview
21 sats \ 1 reply \ @tomlaies 2 Apr 2022
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.
reply
25 sats \ 0 replies \ @k00b 2 Apr 2022
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.
reply
21 sats \ 0 replies \ @k00b 2 Apr 2022
That was some gnarly downtime. Yikes ... have to work on that.
reply