MySQL Forums
Forum List  »  InnoDB

Re: Data length for INNODB tables
Posted by: archana mattoo
Date: February 21, 2018 06:50AM

if we disable the parameter innodb_file_per_table=OFF, innodb will not free up space after deletion.
i had the similar issue where this paramter was off, so when i was deleting data from any table "data_length" was as it is. No change was there in data_length although there should be.

So i turned this parameter on and restart of mysql process freed up space.

But not sure what will happen if i will delete from any other table now.

Options: ReplyQuote


Subject
Views
Written By
Posted
1889
February 14, 2018 01:05AM
771
February 14, 2018 12:19PM
817
February 19, 2018 07:52AM
607
February 19, 2018 01:50PM
Re: Data length for INNODB tables
711
February 21, 2018 06:50AM
706
February 22, 2018 03:13AM


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.