Is there a way to reduce Wordpress hosting costs?

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
Solution:
tl;dr - append --performance_schema=0 to MySQL's start command in its service settings - switch to MariaDB...
Jump to solution
13 Replies
Percy
Percy8mo ago
Project ID: 6ef0683a-911a-4596-90e2-6495d96e7401
Blastoise84
Blastoise848mo ago
6ef0683a-911a-4596-90e2-6495d96e7401
Brody
Brody8mo ago
are you using mysql? I thought the wordpress template comes with mariadb
Blastoise84
Blastoise848mo ago
I am using mysql. I did use a template ~2 months ago. Let me see if I can find it I used this one https://railway.app/template/EP4wIt?referralCode=fKo7dw, which now looks like it uses Mariadb.
Brody
Brody8mo ago
haha yeah, well I bet you can imagine why it uses mariadb now
Blastoise84
Blastoise848mo ago
Haha, OK makes sense. I'll migrate over to Mariadb
Brody
Brody8mo ago
but we can get mysql to use a bit less base memory too 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
Blastoise84
Blastoise848mo ago
Ok that sounds good 👍
Brody
Brody8mo ago
let me find it, one min 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. 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
Blastoise84
Blastoise848mo ago
gotcha! thank you I'll give this a try and report back :salute:
Blastoise84
Blastoise848mo ago
it worked some!
No description
Brody
Brody8mo ago
that do be some
Solution
Brody
Brody8mo ago
tl;dr - append --performance_schema=0 to MySQL's start command in its service settings - switch to MariaDB
Want results from more Discord servers?
Add your server