MYSQL innodb_buffer_pool_size

[daniel smith]

I am running a db-n1-standard-4 15gb ram sql database and the default innodb buffer size is only .5GB. I tried increasing this myself but it requires SUPER privilege. How can I increase this??

[David Newgas]

Cloud SQL automatically sets InnoDB buffer pool size for you. For an db-n1-standard-4 instance it will be 11GB. You can verify this with

mysql> SHOW VARIABLES LIKE 'innodb_buffer_pool_size';

+-------------------------+-------------+

| Variable_name           | Value       |

+-------------------------+-------------+

| innodb_buffer_pool_size | 11811160064 |

+-------------------------+-------------+

On Fri, May 12, 2017 at 9:44 AM, daniel smith <acadi...@gmail.com> wrote:

I am running a db-n1-standard-4 15gb ram sql database and the default innodb buffer size is only .5GB. I tried increasing this myself but it requires SUPER privilege. How can I increase this??

--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/967183fa-1165-417b-97c4-54e321f033d0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.