Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  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

      Attachments

        Activity

          People

            lalit.choudhary Lalit Choudhary
            narodmon Denis K.
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist