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

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.