Hello Jose,
If MySQL server (mysqld) is crashing, and not the instance itself, it could be a utilization issue. Hence, you may check the corresponding graph in the instance overview page, and for testing purposes you may try migrating with a higher CPU/Memory type machine (you have the ability to downgrade after).
But are you sure that the crash is causing the connection issue (could be not related)? For example, and while you replicated the server locally (and not over the internet), it could also (in addition to crashing) be a connection issue like this communication error, and per this troubleshooting guide , this does not indicate that you have an issue with the Cloud SQL instance itself, but the “application is not terminating connections properly”, or caused by a network issue.
On the other hand, and while this is affecting one table, and as you have a special case using named pipes, it would be nice to investigate it through issue tracker. Opening a report, make sure it is private, include your project ID, instance name, all error messages for the behavior described above, and detailed reproduction steps.
Hello Mousa,
From the description it seems like an over-utilized instance, and provisioning additional resources should resolve the issue. However, the instance (VM) itself should not restart but rather the running MySQL server (mysqld). If the instance itself is restarting please open a private issue tracker report including the instance’s connection name for inspection.
Hello Jose,Thank you for the feedback. I believe both cases are different as you are migrating using named pipes/load data infile over the internet, while Mousa is describing heavy write load. In both cases though, the instance itself should not restart. That said, we do appreciate opening the issue tracker for an investigation as it is the platform for discovering defects and improving our products.
--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f0ac28a2-8a52-4f34-9ff7-ee4ccc8c32f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.