MySQL Forums
Forum List  »  InnoDB

Issues with alter table InnoDB
Posted by: ayran abcdef
Date: April 11, 2019 02:42PM

System-specs:
-- MySQL Version 9.10 Distrib 5.5.60
-- CentOS Linux release 7.5.1804 (Core)
-- innodb_file_per_table

Problem:
table status of some innodb tables shows "data_free=4194304".

optimize table [tablename] nor alter table table_name engine='InnoDB' changes data_free to 0 either.

My global variables are set as below in my.cnf file:
innodb_file_per_table=1;
innodb_file_format=Barracuda
innodb_file_format_max=Barracuda

Any clarification would be much appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Issues with alter table InnoDB
133
April 11, 2019 02:42PM


Sorry, only registered users may post in this forum.

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.