Is there a way to reduce Wordpress hosting costs?
Anonymous
TRIALOP

2 years 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

16 Replies

Anonymous
TRIALOP

2 years ago

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


2 years ago

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


Anonymous
TRIALOP

2 years ago

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


Anonymous
TRIALOP

2 years ago

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


2 years ago

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


Anonymous
TRIALOP

2 years ago

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


2 years ago

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


2 years 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
TRIALOP

2 years ago

Ok that sounds good 👍


2 years ago

let me find it, one min


2 years 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.


2 years 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
TRIALOP

2 years ago

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


Anonymous
TRIALOP

2 years ago

it worked some!

1218274847960994000


2 years ago

that do be some


2 years ago

tl;dr

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

  • switch to MariaDB


Loading...