0

I've recently moved some MySQL hosting from a virtual server at Digital Ocean to Google's Cloud SQL hosting. It took several goes to import the database and I didn't notice until afterwards that each time I deleted a database in the Google console it didn't actually reset the storage space that database had used.

I've not got about 40GB of storage but I know the database is only about 10, is there some way to clear the space or do I need to start again and import the database into a fresh db setup?

Caedmon
  • 123
  • 6

1 Answers1

0

Since the data written to the disk is fragmented it is not possible to reduce the size of the Cloud SQL instance without directly affecting your data. This process would require careful defragmentation to ensure that the space being removed does not contain any of your data.

It is therefore recommended to turn off the Automatic storage increase setting for your instance, or set a limit on the size it is allowed to increase to in order to control the size of your Cloud SQL instance.

Jordan
  • 301
  • 2
  • 8
  • Thanks Jordan, strangely though the space being used dropped back down to a sensible level after a couple of weeks... no idea how or why! – Caedmon Nov 09 '17 at 09:41