Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10323

New background analyze table feature not working

    Details

      Description

      Sorry - somehow it has started working fine now - so perhaps it is human error. Please close for now.

      After upgrading to 10.1.15 thought I would try out the new background analyze table feature in TokuDB.

      -https://www.percona.com/doc/percona-server/5.6/tokudb/tokudb_background_analyze_table.html-

      According to Percona's docs, when you start a background job it should provide status via a new information_schema table:

      INFORMATION_SCHEMA.TOKUDB_BACKGROUND_JOB_STATUS

      After running the following command to create the schema table (missed this the first time around in the docs):

      INSTALL PLUGIN tokudb_background_job_status SONAME 'ha_tokudb.so'

      Then the table showed up.. however when I set tokudb_analyze_in_background=ON and run an analyze on a large tokudb table, nothing gets added to that table.

      If I try to run the analyze again, it says "Operation failed" .. suggesting that maybe it IS running the analyze somewhere. Nothing shows up in the background job table, or the running processes to suggest so though.

      Unsure if I'm doing something wrong, or if it's an issue with the feature.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              philsweeney Phil Sweeney
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: