Score:-1

Google Cloud SQL - Database instance storage size increased dramatically everyday

cn flag

I have a database instance (MySQL 8) on Google Cloud and since 20 days ago, the instance's storage usage just keeps increasing (approx 2Gb every single day!). But I couldn't find out why.

What I have done:

  1. Take a look at Point-in-time recovery "Point-in-time recovery" option, it's already disabled.
  2. Binary logs is not enabled.
  3. Check the actual database size and I see my database is just only 10GB in size
  4. No innodb_per_table flag, so it must be "false" by default

The actual database size is 10GB, now the storage usage takes up to 220GB! That's a lot of money!

I couldn't resolve this issue, please give me some ideal tips. Thank you!

John Hanley avatar
cn flag
You have asked this question twice previously. You received comments requesting additional information but you did not respond or update your question. Review those comments and update your question with details to enable an answer. https://stackexchange.com/search?q=Google+Cloud+SQL+-+Database+instance+storage+size+increased+dramatically+everyday
Score:0
in flag

SQL databases get increased from multiple reasosns. It might be from unbalanced indexes and many more.

I would gamble on excessive update or even delete calls. Check if vacuum works for you (there are multiple types of vacuum - analyze, analyze full. Google it)

If it helps it means that something in the application is causing it, either it can be avoided or online periodic vacuum (or offline vaccum full with down time)

Apparently on mysql vacuum is called optimize https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html

Thien Nguyen avatar
cn flag
The size growth happens on the instance, not in the database itself.. idk if the real problem is the database optimize
in flag
well - you can try it :) AFAIK disk size of a database is, well, caused by the database...
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.