Slower mariadb calls across wordpress environments
makorism
HOBBYOP

a day ago

Are all services always within the same region if in the same environment? On my prod environmet my wordpress site makes super fast queries to the mariadb but on staging it's a bit slower and on PR it's even slower.

The actual database call which I tested with ssh: $wpdb->get_var("SELECT 1") timed about doubly as slow on staging and 20x slower on PR

I understand that given there's a bunch of WP settings that may be a factor but I thought that given I'm just making a direct database call the wordpress settings would be less likely to be an issue. It's hard to get a 1-1 identical environment across wordpress sites because copying over all the settings isn't easy but all the container level stuff should be the same. Any ideas? I'm just worried something about the mariadb might just start slowing down on my prod environment because of something I'm not considering right

$10 Bounty

2 Replies

a day ago

Are all services always within the same region if in the same environment?

No, you can set whatever region you want on each individual service, so region locality is something you must check on your end.


makorism
HOBBYOP

a day ago

Both are on the same region across all my environments so probably not that 🤔


Welcome!

Sign in to your Railway account to join the conversation.

Loading...