The INFORMATION_SCHEMA TABLES Table • DATA_FREE • AUTO_INCREMENT • CREATE_TIME • UPDATE_TIME • CHECK_TIME • TABLE_COLLATION The number of allocated but unused bytes. InnoDB  tables report the free space of the tablespace to which the table belongs. For a table located in the shared tablespace, this is the free space of the shared tablespace. If you are using multiple tablespaces and the table has its own tablespace, the free space is for only that table. Free space means the number of bytes in completely free extents minus a safety margin. Even if free space displays as 0, it may be possible to insert rows as long as new extents need not be allocated. For NDB Cluster,  DATA_FREE  shows the space allocated on disk for, but not used by, a Disk Data table or fragment on disk. (In-memory data resource usage is reported by the  DATA_LENGTH  column.) For partitioned tables, this value is only an estimate and may not be absolutely correct. A more accurate method of obtaining this information in such cases is to query the  INFORMATION_SCHEMA PARTITIONS table, as shown in this example: For more information, see Section 26.3.21, “The INFORMATION_SCHEMA PARTITIONS Table” . The next  AUTO_INCREMENT  value. When the table was created. When the data file was last updated. For some storage engines, this value is  NULL . For example, InnoDB  stores multiple tables in its system tablespace and the data file timestamp does not apply. Even with file-per-table mode with each  InnoDB  table in a separate  .ibd  file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. For  MyISAM , the data file timestamp is used; however, on Windows the timestamp is not updated by updates, so the value is inaccurate. When the table was last checked. Not all storage engines update this time, in which case, the value is always  NULL . For partitioned  InnoDB  tables,  CHECK_TIME  is always  NULL . The table default collation. The output does not explicitly list the table default character set, but the collation name begins with the character set name. SELECT SUM(DATA_FREE) FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = ’mydb’ AND TABLE_NAME = ’mytable’; 4828 UPDATE_TIME  displays a timestamp value for the last  UPDATE ,  INSERT , or  DELETE  performed on InnoDB  tables that are not partitioned. For MVCC, the timestamp value reflects the  COMMIT  time, which is considered the last update time. Timestamps are not persisted when the server is restarted or when the table is evicted from the  InnoDB  data dictionary cache.