Cloud SQL MySQL8 crashes every day

[Sebastian Stehle]

Hello together,

we have recently migrated our data from a MySQL5 instance to MySQL8 and also added more resources.

The specs of the old server are:

* 1 vCPU, 3.75 GB Memory, 84 GB SSD

The specs of the new server are:

* 2 vCPU, 7.5 GB Memory, 84 GB SSD  

The old server was at its limit but very stable. For example the memory usage was always very high but it never crashed:

The new server is a totally different story.

It crashes very often. The memory increases until it reaches the maximum and then the server crashes. In the logs we see nothing except a few bad queries that we had before and are about to optimize and the log output that mysql has been started.

We have no good idea and plan what to do at the moment.

[Elliott (Google Cloud Platform Support)]

Hello,

The images that you provided did not make it through. Please provide REDACTED information, meaning not to reveal personal or project specific information.

Thank you.

[Sebastian Stehle]

Yes, I have seen it. But the images do not provide that much value anyway. The first image would have shown that the memory usage is high but stable and the second image would have shown that the memory usage starts at around 3GB, increased during 1 or 2 days to the maximum and goes down again when mysql crashs.

[Christian R.]

Hi Elliott,

do you have any ideas why this is happening? Or how to inspect that behavior? I attached some images, showing stable resources for CPU and IO but a fluttering memory.

The reason for the decreasing memory is an automatic restart / crash, resulting in all our services loosing connection.

[gojuancarlos]

Hello,

If your Cloud SQL MySQL 8 is still crashing I recommend to create a ticket with your support package if you have, or raise a PRIVATE ticket via the issue tracker and provide us with your project id, instance id and the timestamp the issue started happening so that we would be able to dig into the issue.

Reichelt, fluctuating use of resources could be due to fluctuating load, however if your instance is loop crashing follow the line line above.