Skip to main content
We’ve updated our Terms of Service. A new AI Addendum clarifies how Stack Overflow utilizes AI interactions.
edited tags
Link
RolandoMySQLDBA
  • 16.8k
  • 3
  • 51
  • 84
Source Link
corretge
  • 217
  • 3
  • 9

MySQL show table status always returns Data_free 17825792

When I execute SHOW TABLE STATUS databaseName;

I get Data_free info with 17825792 value in all tables :

| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | | ubqACL | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 17825792 | 1 | 2011-08-23 17:45:48 | NULL | NULL | utf8_general_ci | NULL | | Access Control List per a ubqDocs | | ubqAssociacions | InnoDB | 10 | Compact | 1216 | 148 | 180224 | 0 | 262144 | 17825792 | 1246 | 2011-08-23 17:45:48 | NULL | NULL | utf8_general_ci | NULL | | Vincles entre documents | 

the database engine is InnoDB.

I want to retrieve this value for calculate fragmentation and trigger optimization actions.