MySQL railway db is slow and use full memory
Hello, I am using Spring Boot, Thymeleaf, and MySQL in my project on a Hobby plan. The pages are taking 15-20 seconds to load, and the queries are loading very slowly. What should I do?
21 Replies
Project ID:
N/Awhen did you deploy this mysql service?
I was actually using the free plan until two hours ago, and I still had credits left. However, I switched to the hobby plan one hour ago, and the queries are still running slowly as they used to.
Simple blog website
my project
that memory usage is very normal for mysql
I have never seen mysql use less than 400mb even when deploying a fresh database
try connecting to the database from desktop software like dbgate and run some queries, let me know how long those take
I will try to do what you suggested.Do you have any other suggestions, sir? Would upgrading to a higher plan resolve the issue? Or if I switch to PostgreSQL, would it help?
the pro plan wouldn't magically make queries faster unfortunately
does your database have a volume attached to the service?
Are you asking if it has this?
yep that answers the question
well let me know how long queries take from dbgate and then well go from there
Alright, sir, I've never tried it before, I'll look for any documentation or videos on how to do it.
just download dbgate, install it, connect to your database on railway and run some simple queries
It took 10 seconds just for 8 data
skull emoji indeed
10 seconds is a lot of time for us-west1 to anywhere in the world, but just for context, roughly where would you be located?
I don't know what to do, maybe it's because I live in Turkey. How can I solve this problem?
does your app have any kind of healthcheck endpoint?
unfortunately, it's not available.
would you be interested in upgrading to pro if you had a guarantee the query times would improve?
Yes, but I have a question. I'm a new member, and I'd like to ask: Do you charge a fixed fee every month, or do I pay based on usage?
- for the hobby plan there is a fixed 5$ subscription fee, this also comes with 5$ in credits you can use towards usage. any usage above 5$ is charged
- for the pro plan it is a 20$ subscription per seat (team member) and it does not come with any resource credits. any usage is charged
if you are interested in upgrading to pro, you can dm me and ill run a mysql database in the Netherlands so you can test the query times, since that would be the closest region to turkey
You're welcome! I really appreciate your help, I accept it.
i think i enabled dms, can you dm me?
edit: will be working through this in dms, ill update here once a solution has been meet