Ultra slow mysql responses

hannes_newnowPRO

8 months ago

Hi, since 2h my application is only getting ultra slow mysql reponses. I already restartet the application and the db. Didn't help. After restarting my mysql memory keeps beeing at around 2-3gb, which was at 9gb before... are there any know incidents at the moment?

Awaiting User Response

5 Replies

hannes_newnowPRO

8 months ago

The memory keeps scaling very slowly:

Attachments


hannes_newnowPRO

8 months ago

After half a day the memory still hasnt gone back to it's inital level....

Attachments


8 months ago

Hey there Hannes,

Unfortunately, the reality of MySQL in a container is that you are going to have quite high memory usage on the platform.

With the default configuration: MySQL 8's default configuration is designed for general-purpose use and may allocate more memory than necessary for containerized environments, this is because of the InnoDB buffer pool.

Off hand, I wouldn't be able to provide advice on tuning your database but if need be you can try a number of options and going from there.

(I also re-spun an invite to Slack but it's not tied to your Jobwork email, if you give me that, I can invite you over.)

Thanks,
Angelo


Status changed to Awaiting User Response railway[bot] 8 months ago


hannes_newnowPRO

8 months ago

Hi Angelo, I dont mind if it uses a lot of memory. In fact I was wondering why it now uses less than before. It seems way slower than it used to be 2 days ago....


Status changed to Awaiting Railway Response railway[bot] 8 months ago


8 months ago

I wouldn't be able to know without traces and profiles on your end. From my end, the hosts during this period are healthy with plenty of head room.


Status changed to Awaiting User Response railway[bot] 8 months ago