[google-cloud-sql-discuss] Re: Database crashes periodically

I have see this crash too.It looks like it relate to the mysql server use too much memory.

Use big memory instance will delay this problem, but it can not solve it.

I think it may have too many transactions which is not commit in the memory.

It looks like there is no way to reduce innodb_buffer_pool_size.I can not set it from start, and do not have permission to do that even if I use the root mysql account.

On Thursday, September 21, 2017 at 10:29:10 PM UTC+8, 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/e9fc50ab-11e6-4f57-aef7-ce941317d8b8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.