Reclaim space?

91 views
Skip to first unread message

T.R.

unread,
Oct 31, 2013, 9:40:55 AM10/31/13
to google-cloud...@googlegroups.com
According to information schema I'm using less than 10 gig of space after dropping a 80+ gig table.
However the console shows disk usage at 97 gig.
The large table I dropped was over 12 hours ago.
Is there some way to reclaim space?

Thanks,

T.R.

Razvan Musaloiu-E.

unread,
Oct 31, 2013, 10:33:48 AM10/31/13
to google-cloud...@googlegroups.com
Currently, the only to do that is to dump the data and recreate another instance using that. For performance reasons we don't use innodb_file_per_table and, sadly, Innodb never shrinks the default tablespace.

-- Razvan ME


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/7c48933b-d9f8-47e3-b8bb-3bf621c3fcfc%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply all
Reply to author
Forward
0 new messages