Google Groups discussion forum is meant for open-ended discussions. This sounds like a technical support question which are best suited for Stackoverflow. Make sure to use valid tags.
Just to mention, it could also turn out to be project/application specific in which case you can consider opting for one of the support packages.
To answer the questions, reducing the buffer(innodb_buffer_pool_size) may resolve memory issues such as this, you can find more details here. About Cloud SQL using all the memory automatically, has to be seen at the project level and depends on the use case that why is it doing so.
On Thursday, September 21, 2017 at 10:29:10 AM UTC-4, Ed Bailey wrote:
We are having a problem where our cloudSQL database crashes periodically.The error we are seeing in the logs is:[ERROR] InnoDB: Write to file ./ib_logfile1failed at offset 237496832, 1024 bytes should have been written, only 0 were written. Operating system error number 12. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.From what I understand, error number 12 means 'Cannot allocate memory'. Is there a way we can configure cloudsql to leave a larger buffer of free memory? The alternative would be to upgrade to have more memory, but from what I understand cloudSQL automatically uses all the memory available to it... Is this likely to reduce the problem or would it likely continue in the same way?Are there any other things we can do to reduce this issue?
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/b39c5487-0151-4838-91fa-5386c2428265%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment