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

MariaDB spider performance

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • Storage Engine - Spider
    • ##spider###
      spider_conn_recycle_mode = 1
      optimizer_switch = 'engine_condition_pushdown=on,mrr=on,mrr_sort_keys=on'

      spider_version:3.2.37

    Description

      My I ask a question about spider's performance issues.

      I am a financial company DBA, the project selected spider storage engine to do the table split, and now meet a problem, spider's performance has not been promoted up, I would like to ask which parameters should be adjusted? Thank you!

      By the way ,when maxscale can support the table split?

      Attachments

        Issue Links

          is duplicated by

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-7698 Spiral patches

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            JIRA is not the best place for getting this sort of feedback. You can acquire wider variety of opinions and response by using community mailing llists, such as maria-discuss@lists.launchpad.net .

            stephane@skysql.com, would you like to answer this here?

            elenst Elena Stepanova added a comment - JIRA is not the best place for getting this sort of feedback. You can acquire wider variety of opinions and response by using community mailing llists, such as maria-discuss@lists.launchpad.net . stephane@skysql.com , would you like to answer this here?
            stephane@skysql.com VAROQUI Stephane added a comment -

            Regarding Spider table split performance , we can't really provide performance improvement as of the state of MariaDB today. To Improve the performance MariaDB Server as to be modified and this is a work in progress that will happen in 10.3 with the sponsoring of many clients. I invite you to join this effort , that will give you access to some modify spiral release of 10.0 and 10.1 that work great for performance ends up with a 10.3 that will stop diverging from the trunk. When you get such a release i can guide you to get performance improvements.

            stephane@skysql.com VAROQUI Stephane added a comment - Regarding Spider table split performance , we can't really provide performance improvement as of the state of MariaDB today. To Improve the performance MariaDB Server as to be modified and this is a work in progress that will happen in 10.3 with the sponsoring of many clients. I invite you to join this effort , that will give you access to some modify spiral release of 10.0 and 10.1 that work great for performance ends up with a 10.3 that will stop diverging from the trunk. When you get such a release i can guide you to get performance improvements.
            elenst Elena Stepanova added a comment -

            I assume it is MDEV-7698, then.

            elenst Elena Stepanova added a comment - I assume it is MDEV-7698 , then.

            People

              Unassigned Unassigned
              hiller1 hiller1
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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