0

We are testing the Google Cloud SQL service and we have a problem when importing our database.

Imported file include this command:

DROP DATABASE $my_db

But Google Cloud SQL dashboard still shows a storage size as if nothing was deleted.

Is it the right method for deleting a database without removing the supporting VM?

I don't want to delete the whole VM as instance names seem to be reserved for two months.

doelleri
  • 19,232
  • 5
  • 61
  • 65
Manel
  • 1,616
  • 19
  • 42

1 Answers1

2

InnoDB will hold onto the data that it has allocated itself, so when you create a database and delete it, the storage usage remains the same. This means you can't reduce the maximum storage you have used, but InnoDB will recycle the space it has reserved if you import new data.

cflewis
  • 7,251
  • 7
  • 28
  • 37