Re: [google-cloud-sql-discuss] Re: CloudSQL size

Can you post a screenshot of which property of the instance you are referring to? 

Are you referring to the data size as shown by the storage chart or the instance disk size?

The first should reflect the size of the actual data on disk whereas the second could be larger since it is the maximum capacity.

One common source of unexpected disk growth is from MySQL temporary tables, though if this is the case the actual storage should go down after the query is done (though the total disk will not go down since it can only grow).

On Tue, Sep 5, 2017 at 11:38 AM, Giuliano Ribeiro <giuliano.ribeiro@ilegra.com> wrote:

I've been doing this manually, as the DB is gain size it's stopping to work, so I need to increase the size manually.

On Tuesday, September 5, 2017 at 6:35:12 PM UTC+1, Giuliano Ribeiro wrote:

No, the "Automatic storage increase" is not enable.

On Tuesday, September 5, 2017 at 6:30:18 PM UTC+1, Shivam(Google Cloud Support) wrote:

So "Automatic storage increase" was enabled? As discussed, size of Cloud SQL 2nd gen instance cannot be decreased. Even if you are cleaning up your DB everyday, size increased once cannot be decreased.

On Tuesday, September 5, 2017 at 8:02:15 AM UTC-4, Giuliano Ribeiro wrote:

Hi Shivam, I even delete all my backup and turned off this feature.

The DB right now have 31mb in one schema and 890mb in another, but CloudSQL dashboard is showing me up 146GB.

Do you have any idea about it?

Thank you,

On Monday, September 4, 2017 at 6:26:43 PM UTC+1, Shivam(Google Cloud Support) wrote:

Do you have 'Automatic storage increase' option enable for your Cloud SQL instance? This setting calculates a threshold based on the current instance size and adds additional storage capacity automatically to the instance. This makes sure that your instance continues to serve as your database is growing.

Do you know if your database size ever reached a value closer to 146 GB? In this case, Automatic storage increase' option has added this additional capacity to the instance. There is currently a feature request in place to allow decreasing the size of Cloud SQL 2nd gen instance as it cannot be decreased currently. I recommend to star the feature request to receive any future updates.

On Monday, September 4, 2017 at 8:06:11 AM UTC-4, Giuliano Ribeiro wrote:

Hello all, 

I have a database on the 2nd gen which is only a temporary db, I continuously receive data, process them with procedures and then clean up all data. 

In the end of the day, my DB have no more then 30Mb.

But the weird is the DB grown up in size, right now it is 146Gb, but if I do a export or get the table sizes, it takes only 30mb.

I tried to delete the backups and restart the DB, but no size reduce. The binary option is disabled as well.

Do you know how CloudSQL count the DB size?

Thank you.,

--
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/404205dc-f4d6-4336-81f3-5a3567d0a3af%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/CABDU3p0upVpTeCfAanPqXCMzOoXeFbnaZwUmbD5yQg6aWfnG3w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.