My mysql server disk size is 775GB. But the actual database is only 24GB.

[PRIYA JOSEPHSELVAM]

My mysql server disk size is 775GB. But the actual database is only 24GB. Google is charging me lot of money. how to fix it? 

[Olu]

Hello, Priya

I understand you would like to know a way in which you could reduce the Size of your CloudSQL instance, consequently, reducing your Billing Charges for the present storage. Sadly, at the moment, there is no way to actually achieve this[1]. There is a feature request[2] available for this implementation and the CloudSQL team are reviewing the possibility, how it fits into the Road-map of CloudSQL. At the moment, however, this is not possible. 

A workaround, as addressed in this Stackoverflow link[3] would be to create an SQL dump file[4] of your CloudSQL Database, create a new Cloud SQL instance with the desired capacity, then import the SQL dump file so that all your data is stored in the new instance.

[1]https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen

[2]https://issuetracker.google.com/63069754

[3]https://stackoverflow.com/questions/50737635/how-to-reduce-google-cloud-sql-instance-size

[4]https://cloud.google.com/sql/docs/mysql/import-export/exporting#export-mysqldump