Thursday, January 28, 2016

Re: [google-cloud-sql-discuss] 1 GB storage used when empty? 512MB RAM used when idle? (2G)

Hi Melvin,

f1-micro has 0.6GB of RAM. A lot of it is pre-allocated to the InnoDB buffer pool which is why it may show up as "used", but it doesn't necessarily mean MySQL is actively using all of it at any given time.
The 1GB used comes from the disk space pre-allocated for the InnoDB redo log.

Hope this helps,
 - Vadim

On Thu, Jan 28, 2016 at 7:23 PM Melvin Sommer <sommer.melvin@gmail.com> wrote:
Hey guys,

I'm using the Google Cloud products for the first time and have an SQL server set up for an app I'm currently deploying.
The SQL instance is a db-f1-micro tier, with 10GB storage reserved, of the second generation.

Now, I'm noticing that when the app is idle and there's no DB interaction, my admin panel shows 512MB RAM usage for the instance (whereas the tier should indicate a 125MB cap), and 1GB of storage space is used when it is actually empty.

Does any of this sound familiar? Do you have any pointers for me to get this issue resolved?

--
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/47e88c57-8d4d-4e7e-8449-08c40e31cb44%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p0OXx8CCQU5ih-G%3Dai_g7QhW5Ggauutc%3DKFe9x%3DQr3Qww%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment