This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

The storage usage of cloud sql of my gcp is abnormally high.

Posted on 12-12-2022 05:33 PM
juhopark
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

The storage usage of cloud sql of my gcp is abnormally high.
The sum of data_length and index_lenght in information_schema.tables was only 0.42G.
However, the storage usage confirmed by monitoring is 11G.
Please let me know what makes the difference between the two.

0 2 824
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
christianpaula
Staff
Reply posted on --/--/---- --:-- AM

Hi @juhopark,

Welcome to Google Cloud Community!

 

It is likely that the difference in storage usage between the data_length and index_length columns in the information_schema.tables table and the storage usage reported by Google Cloud Platform's monitoring is due to additional overhead associated with storing the data in a database. 
 
This overhead can include additional data structures used by the database management system to track and manage the data, as well as any additional space required to support features such as replication and backups. 
 
It is also possible that the storage usage reported by Google Cloud Platform's monitoring includes additional storage for other resources associated with your cloud SQL instance, such as logs and temporary files.
 
Thank you.
0 Likes

Posted on --/--/---- --:-- AM
byeoldal
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

The storage usage reported by monitoring in GCP Cloud SQL might include additional overhead such as replication data, logs, temporary files, and system metadata. These factors can contribute to the difference between the sum of data_length and index_length in information_schema.tables and the actual storage usage reported by monitoring tools.