MySQL Forums
Forum List  »  Install & Repo

Re: Disk Space
Posted by: jean touzalin
Date: April 02, 2014 10:47AM

On my opinion, it is not possible to shrink a tablespace without recreating it.

You can verify what size is used for your Innodb tables
select (sum(data_length)+sum(index_length))/1024/1024/1024 as "size Gb" from information_schema.tables
where engine='INNODB';

regards

Options: ReplyQuote


Subject
Written By
Posted
April 01, 2014 03:09AM
April 01, 2014 04:26AM
April 02, 2014 02:20AM
Re: Disk Space
April 02, 2014 10:47AM
April 03, 2014 02:08AM
April 04, 2014 08:12AM
April 07, 2014 03:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.