Issues with alter table InnoDB
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.
Subject
Views
Written By
Posted
Issues with alter table InnoDB
834
April 11, 2019 02:42PM
413
April 11, 2019 03:01PM
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.