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

    XMLWordPrintable

    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:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: