R
Railway7mo ago
André

Mysql high memory usage

Hi, is there a way to reduce the standby memory usage of the mysql service or maybe to configure mysql on my own? This is currently resulting in unnecessary costs as the service is not really used most of the time
No description
Solution:
I have seen a lot of screenshots of mysql's memory metrics and 430ish mb is perfectly normal for mysql, that's just how it is. I'd recommend giving my mariadb template a try, it should be a drop in replacement for mysql in a lot of cases, and it would use roughly half the idle memory. https://railway.app/template/Onvy0F...
Jump to solution
13 Replies
Percy
Percy7mo ago
Project ID: aad8507c-66a2-4923-9502-c21c1762f332
André
André7mo ago
aad8507c-66a2-4923-9502-c21c1762f332
Solution
Brody
Brody7mo ago
I have seen a lot of screenshots of mysql's memory metrics and 430ish mb is perfectly normal for mysql, that's just how it is. I'd recommend giving my mariadb template a try, it should be a drop in replacement for mysql in a lot of cases, and it would use roughly half the idle memory. https://railway.app/template/Onvy0F
André
André7mo ago
Thank you very much, I'll test that. Yes 430 isn't that high but for idling still generating unnecessary costs
Brody
Brody7mo ago
unfortunately thats just how mysql is
André
André7mo ago
Yep, Unfortunately it is...
Brody
Brody7mo ago
so yeah, give mariadb a try specifically the template i linked
André
André7mo ago
Let me check Yes indeed, that works and is propably the better solution as using postgre. I am now at 220mb memory. Thank you very much for this tip! Really appreciate it salute
Brody
Brody7mo ago
no problem!
Robbyn R
Robbyn R7mo ago
how to deploy your template to an existing project? or move service to antoher project?
Brody
Brody7mo ago
open your project > + new > template > mariadb, dont deploy the one that doesnt say image deploy
No description
Robbyn R
Robbyn R7mo ago
Thank you. i can add maria db now. I confused because i usually deploy new service with right click (no template option when right click) i think its better to add "Template" 😄
No description
Brody
Brody7mo ago
yeah ideally template should be in that context menu