MySQL Issues – Disk Usage and Connection Failure
floathealthbrasil
PROOP

3 months ago

Hello Support Team,

I am experiencing two issues with my MySQL database on Railway:

  1. Database Size

    My database is showing 1.31 GB in use, but my WordPress installation is empty. This seems unusual since it should not be consuming that much space.

  2. Connection Failure

    I am unable to connect to the database.

    The error message is:

Connection failed! Unable to connect to host mysql-homolog.up.railway.app, or the request timed out.

Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).

MySQL said: Can't connect to MySQL server on 'mysql-homolog.up.railway.app:3306' (60)

Could you please check these two points?

  • Why the database is occupying so much space.

  • Whether there is an issue with the MySQL instance preventing the connection.

Thank you for your support!

Best regards,

Solved$20 Bounty

6 Replies

Railway
BOT

3 months ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!

brody
EMPLOYEE

3 months ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Open brody • 3 months ago

noahd
EMPLOYEE

3 months ago

Hey there! If you recently restored a backup to your MySQL database you might be using a different database name (the default railway database is railway). Would suggest checking to verify that!
As for the size, I've seen a few WP projects people are reporting 1-5g as their SQL dump size. Sounds odd but seems to be consistently around the 1-2g range.

In regards to the connection failure, if you look at the variables tab I suggest using the private URL!
It's best for speeds that services on the same project use the internal private URL.

Any more info you're able to provide is greatly appreciated!

floathealthbrasil
PROOP

3 months ago

  • I have not restored any recent backup, so the database name should not have changed.

  • The internal connection works fine — WordPress is able to connect to the database without issues.

  • The problem happens only when I try to connect externally from my Mac (outside of Railway). I keep getting the error:

Can't connect to MySQL server on 'mysql-homolog.up.railway.app:3306' (60)

Could you please confirm if external connections to the database are allowed, or if there are any additional steps/configurations required to connect from outside Railway?

Also, regarding the database size — it is strange because the WordPress instance is empty. Could you please double-check why the database is consuming 1.31 GB?

Thanks a lot for your help!

Best regards,
Will

fra
HOBBY

3 months ago

Is your public domain enabled on the expected port? can you try connecting without specifing the db?

is not clean but given wp works you could try adding something like adminer just to check why the db is so big...

4rweb
HOBBY

3 months ago

You need to change the URL! This URL is probably incorrect! Usually the URL for public access is this one: ...proxy.rlwy.net

+11
floathealthbrasil
PROOP

3 months ago

@4rweb! Thank you! That's it! The URL was incorrect!

Status changed to Solved brody • 3 months ago

Loading...