0

Few days ago instance's size in Cloud SQL stucked. There was a lot of data (~164 GB) but two days ago database was greatly maintained and cleaned, so now it takes much less space (~10-20 GB I think). Developers Console still shows "163.9 GB of 250 GB". Don't know how to force size update. Restart did not help.

And also a strange thing with backups at "Operations" tab: Aug 17, 2014 7:10:07 AM Backup Done An unknown error occurred On "Overview" tab the last backup in the list is from August 14. So the backups are broken.

May be, there is a hidden link between these two.

Any thoughts?

Andrey Y.
  • 13
  • 2

1 Answers1

0

Those are probably unrelated.

See: MySQL InnoDB not releasing disk space after deleting data rows from table.

You will need to contact Cloud SQL support directly for the issue with your backup. Email them at cloud-sql@google.com and include the instance name.

Community
  • 1
  • 1
Juan Enrique Muñoz Zolotoochin
  • 3,429
  • 2
  • 29
  • 37
  • Thank you, I got it. The solution is to export instance's data, remove instance, create it again and import data from saved file. Dropping tables will give no effect. – Andrey Y. Aug 20 '14 at 20:07
  • Backups are fixed by Google, now it's ok. – Andrey Y. Aug 20 '14 at 20:08