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
a year ago
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.
a year ago
haha yeah, well I bet you can imagine why it uses mariadb now
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
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
gotcha! thank you I'll give this a try and report back <:salute:1137099685417451530>
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