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:Jump to solution
tl;dr
- append
--performance_schema=0
to MySQL's start command in its service settings
- switch to MariaDB...13 Replies
Project ID:
6ef0683a-911a-4596-90e2-6495d96e7401
6ef0683a-911a-4596-90e2-6495d96e7401
are you using mysql? I thought the wordpress template comes with mariadb
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.
haha yeah, well I bet you can imagine why it uses mariadb now
Haha, OK makes sense. I'll migrate over to Mariadb
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
Ok that sounds good 👍
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 anywaygotcha! thank you I'll give this a try and report back :salute:
it worked some!
that do be some
Solution
tl;dr
- append
--performance_schema=0
to MySQL's start command in its service settings
- switch to MariaDB