Is there a way to reduce Wordpress hosting costs?

Anonymous
TRIAL

a year ago

Is there anyway to tune the MySQL costs? I have a low traffic site that is costing me $8/mo on Railway, when it would be over-provisioned on a $5/mo Digital ocean VPS. Thank you

0 Replies

Anonymous
TRIAL

a year ago

6ef0683a-911a-4596-90e2-6495d96e7401


a year ago

are you using mysql? I thought the wordpress template comes with mariadb


Anonymous
TRIAL

a year ago

I am using mysql. I did use a template ~2 months ago. Let me see if I can find it


Anonymous
TRIAL

a year ago

I used this one https://railway.app/template/EP4wIt?referralCode=fKo7dw, which now looks like it uses Mariadb.


a year ago

haha yeah, well I bet you can imagine why it uses mariadb now


Anonymous
TRIAL

a year ago

Haha, OK makes sense. I'll migrate over to Mariadb


a year ago

but we can get mysql to use a bit less base memory too


a year ago

I don't think that would be necessary, let's try getting your current database to use less memory first, as that would be far easier than swapping databases


Anonymous
TRIAL

a year ago

Ok that sounds good 👍


a year ago

let me find it, one min


a year ago

append --performance_schema=0 to the start command in the service settings, doing so dropped my idle memory of a freshly deployed mysql database from 490MB to 177MB, your experience may vary on account of your database has data in it.


a year ago

on account of its name, disabling that config makes it seem like it's going to make the database perform worse, but fortunately that's not the case as that only disables metrics collections that we couldn't even really utilise on railway anyway


Anonymous
TRIAL

a year ago

gotcha! thank you I'll give this a try and report back <:salute:1137099685417451530>


Anonymous
TRIAL

a year ago

it worked some!

1218274847960994000


a year ago

that do be some


a year ago

tl;dr

  • append --performance_schema=0 to MySQL's start command in its service settings

  • switch to MariaDB