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

Huge slow down in query performance. ENGINE=SPHINX

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • Ubuntu Jammy

    Description

      Query using SphinxSE.
      When using 10.10.1 or 10.9.2 and earlier.
      The queries are super quick.
      30 rows in set (1 min 32.022 sec)

      After upgrading 10.10.2, and 10.9.3 the same query
      30 rows in set (0.125 sec)

      When running explain on the query type=eq_ref on the quick version.
      and eq|filter on the slow one.

      Disabling eq|filter with
      set @@optimizer_switch="rowid_filter=off";
      Resolved the issue.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dmiogue Dave Minogue
              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.