[google-cloud-sql-discuss] Re: Cloud SQL MySQL8 crashes every day

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.

On Friday, November 20, 2020 at 3:46:11 PM UTC+1 reichelt....@gmail.com wrote:

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.

seba...@squidex.io schrieb am Freitag, 6. November 2020 um 20:30:25 UTC+1:

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.

On Friday, November 6, 2020 at 7:45:47 PM UTC+1 Elliott (Google Cloud Platform Support) wrote:

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.

On Friday, November 6, 2020 at 12:02:10 PM UTC-5 seba...@squidex.io wrote:

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.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/74ef93f9-300e-40eb-bd35-184891b9808dn%40googlegroups.com.