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

Remove internal parser usage from InnoDB fts

Details

    • Q2/2025 Development

    Description

      InnoDB fulltext index internally uses the parser to fetch, write the string into
      the auxilary table, common tables, deleted, deleted cache table

      Make the auxilary tables as a part of fts_index_cache_t and doesn't allow the
      auxilary table to evicted. Store the common tables as a part of
      fts_cache_t. This could avoid taking dict_sys.mutex whenever fts uses
      internal parser.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11633 Make the InnoDB system tablespace optional

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34999 ha_innobase::open() should not acquire dict_sys.latch twice

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä added a comment -

            I think that this may be infeasible to fix in versions older than 10.6, where the InnoDB dictionary cache handling was simplified by MDEV-24258 and other work. We might also decide that this is too risky to fix in any GA release.

            marko Marko Mäkelä added a comment - I think that this may be infeasible to fix in versions older than 10.6, where the InnoDB dictionary cache handling was simplified by MDEV-24258 and other work. We might also decide that this is too risky to fix in any GA release.
            thiru Thirunarayanan Balathandayuthapani added a comment -

            Attaching the parser removal prototype patch in this MDEV page. mdev-28730.patch

            thiru Thirunarayanan Balathandayuthapani added a comment - Attaching the parser removal prototype patch in this MDEV page. mdev-28730.patch
            marko Marko Mäkelä added a comment -

            I’m not sure, but this could help reduce contention on dict_sys.latch.

            marko Marko Mäkelä added a comment - I’m not sure, but this could help reduce contention on dict_sys.latch .

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.