Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5704

Data_free value is too big in SHOW TABLE STATUS

    Details

      Description

      Good day.

      In some tables Data_free value is a really big 18446744073709150790 or 18446744073697848158, etc.

      These tables are very small - less than 1 MB and less than 1000 rows.

      Max_data_length is 9223372036854775807.

      Rows and Data_length are correct.

      Index_length are different in these tables.

      Engine = TokuDB

      Row_format = tokudb_zlib / tokudb_lzma

      Recreating tables and analyze has no effect.

      Restarting the database has no effect.

      In my.cnf :

      innodb stats auto recalc = ON (default)

      innodb stats on metadata = ON / OFF (no effect)

      innodb stats persistent = ON / OFF (no effect)

      innodb stats method = nulls_equal (default)

      OS = CentOS 6.9

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                lalit.choudhary Lalit Choudhary
                Reporter:
                narodmon Denis K.
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: