Slow database queries on MySQL. Up to 83 seconds query time!!!

Question

I encounter very slow database queries using the official MySQL template from railway. This DELETE query for example:

```

DELETE FROM `bxtool_two_factor_code`

WHERE `bxtool_two_factor_code`.`id` = ?;

```

took 84 seconds to run.

And this (read query):

```

SELECT

`id`,

`user_id`,

`token`,

`expires_at`,

`ip_address`,

`user_agent`,

`created_at`,

`updated_at`

FROM `session`

WHERE `session`.`token` = ?;

```

took 53 seconds to run.

Usually, all queries run super fast. However sometimes during the day one query holds up the request for so long that it times out.

After some research I discovered that the root cause might be the railway volume attached to the MySQL service.

I found this [railway question]([https://duckduckgo.com](https://station.railway.com/questions/ever-since-moving-to-railway-metal-my-sq-c7b6a418)) about a slow query case that somebody had with MySQL one year ago. It has been marked as completed but I doubt that. During the conversation the engineering team said they applied a fix but the user who opened the question still observed slow queries.

The "railway volume" issue with slow queries needs more clarification and attention!

It is also not excluded that the problem may be elsewhere...