Is it possible to change the default config of a Mysql Container?
Anonymous
TRIALOP

2 years ago

By default the container uses up a minimum of 500mb of ram, I found a stack overflow post on how to reduce this initial RAM allocation.

Is there an easy way to change the config from within Railway or should I create a custom docker image?

https://stackoverflow.com/questions/10676753/reducing-memory-consumption-of-mysql-on-ubuntuaws-micro-instance

26 Replies

Anonymous
TRIALOP

2 years ago

N/A


2 years ago

very interesting findings, I will definitely look for a way to apply these settings to a mysql database on railway!


2 years ago

easy enough, simply append --performance_schema=0 to the start command, doing so dropped my idle memory of a freshly deployed mysql database from 490MB to 177MB


Anonymous
TRIALOP

2 years ago

@Brody Legend thanks a lot! 😁


2 years ago

no problem!


Anonymous
TRIAL

2 years ago

Testing this out for myself


2 years ago

nice Brody! wonder if we should add this to the template


Anonymous
TRIAL

2 years ago

I get this when i added that to my start command… i must be putting it in the wrong place


Anonymous
TRIAL

2 years ago

1215726356625891300


Anonymous
TRIAL

2 years ago

1215726478290063400


2 years ago

prob need to put it at the end


Anonymous
TRIAL

2 years ago

yep, didnt crash


Anonymous
TRIAL

2 years ago

now i need to wait like an hour or something to see if it drops


2 years ago

it might be worth it, the extra memory is used for database monitoring that i dont even think you could utilize on railway


Anonymous
TRIAL

2 years ago

good god


Anonymous
TRIAL

2 years ago

1215728851901087700


Anonymous
TRIAL

2 years ago

Brody the wizard strikes again


2 years ago

this also would allow trial plan users to run the mysql databases


Anonymous
TRIAL

2 years ago

thats so odd, i wonder what else could be turned of now lol


2 years ago

im sure there are other things, don't know if they could be tweaked via cli flags though


Anonymous
TRIAL

2 years ago

after deleting the other project i wasnt even using and this according to my calculations at least while idle right now it should be 3.96, Ill add making dominican sazon to the list of stuff to give / teach you 😂 , thanks again brody


2 years ago

happy to help 🙂


Anonymous
TRIAL

2 years ago

whats this? 🤔


2 years ago

their internal system to track tasks and such


Anonymous
TRIAL

2 years ago

ah I thought it was some railway feature


2 years ago

haha not quite


Loading...