R
RailwayNuckFuggets

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

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
Solution:
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
Stack Overflow
Reducing memory consumption of mysql on ubuntu@aws micro instance
I have recently started on a PoC project wherein we are developing a small web app. The initial setup is done on a micro instance from AWS. We are on rails+mysql stack. After installing/running My...
P
Percy46d ago
Project ID: N/A
N
NuckFuggets46d ago
N/A
B
Brody46d ago
very interesting findings, I will definitely look for a way to apply these settings to a mysql database on railway!
Solution
B
Brody46d 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
N
NuckFuggets46d ago
@Brody Legend thanks a lot! 😁
B
Brody46d ago
no problem!
C
CookieMonzteh44d ago
Testing this out for myself
M
Melissa44d ago
nice Brody! wonder if we should add this to the template
C
CookieMonzteh44d ago
I get this when i added that to my start command... i must be putting it in the wrong place
C
CookieMonzteh44d ago
No description
C
CookieMonzteh44d ago
No description
M
Melissa44d ago
prob need to put it at the end
C
CookieMonzteh44d ago
yep, didnt crash now i need to wait like an hour or something to see if it drops
B
Brody44d ago
it might be worth it, the extra memory is used for database monitoring that i dont even think you could utilize on railway https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
C
CookieMonzteh44d ago
good god
C
CookieMonzteh44d ago
No description
C
CookieMonzteh44d ago
Brody the wizard strikes again
B
Brody44d ago
this also would allow trial plan users to run the mysql databases
C
CookieMonzteh44d ago
thats so odd, i wonder what else could be turned of now lol
B
Brody44d ago
im sure there are other things, don't know if they could be tweaked via cli flags though
C
CookieMonzteh44d 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
B
Brody44d ago
happy to help 🙂
L
Linear44d ago
Issue LOG-1581 created.
LOG-1581 - add performance_schema to mySql start command
Status
Triage
Assignee
Melissa Hale
Logistics
C
CookieMonzteh44d ago
whats this? 🤔
B
Brody44d ago
their internal system to track tasks and such
C
CookieMonzteh44d ago
ah I thought it was some railway feature
B
Brody44d ago
haha not quite
Want results from more Discord servers?
Add your server
More Posts
Cannot link, login nor logout with cli>railway logout 🚨 Response not successful status=404 >railway login 🚨 Response not successful staLost 2FA code for my accountI have lost my 2FA authenticator codes and I would like to reset my accountHow does it work the HD allocationI need 360gb to use how much does it cost?how to restore postgres db from dumb?i was given my db archives because my db was deleted due to migration. I am trying to restore the dbActivate SSL on my custom domainHello, I bought the domain apocolinks.com at DreamHost.com, this domain already has an active SSL ceBest way to secure postgres?What would be the best way to secure my postgres instance from outside connections? I would just turdeployments "Crashed"Hello, good afternoon, my problem is: deployments "Crashed" and the information in deploy logs MessaHow to use railway with monorepo?I created a new project and essentially my server code is not at the top level, and instead is one dHow can i set a limit?How can i set a limit per month?How can i pause my deployed MySQL Database before my trial plan ends?My project is named "amakusersdb".Cache mount ID is not prefixed with cache keyI'm getting the error above with this Dockerfile: ```dockerfile ARG NODE_VERSION=20.11.1 # Alpine Made a Paid account with Email and linking it with GitHub makes a separate trial accountHello Guys! I bought Railway Hobby plan three days ago and I'm trying to build my apps on Railway. Bredis-LaravelMy redis service is 098aa7a0-0133-4b8c-97a8-bf792e166423 My laravel service is 388e216e-5872-4cc4-8bPUPPETER AND PDFI need help i am having problem randomly to launch puppeter. i use the instance only to create a PDF<--- JS stacktrace --->FATAL ERROR: Ineffective mark-compacts near heap limit Allocation failed -Why do i keep getting this error ? I'm on the Hobby Plan Project ID : 3aa4ba7e-f1f4-4c47-b0e7-162Ioredis Node connection issue.```javascript const redisConnection: RedisOptions = { host: `http://${process.env.REDIS_HORailway volumes in Django not working as expectedHello! I added a Volume to my Django project on Railway for persistent storage of PDF-Generated filIs railway downI'm unable to access my dashboard and when I query my database it was emptyHow to set --shm-size 128m on railway Postgres database dockerThere's a issue on github telling more about it https://github.com/docker-library/postgres/issues/41In my Astro site one of the routes is routing to localhostHello. I am trying to move my Astro site from Vercel, where it is currently working without problems