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

SUGGESTION: Deafult MariaDB Server Configuration Variables -

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None

    Description

      Dear MariaDB Developers,

      I am writing to suggest that MariaDB changes its default innodb_read[write]_io_threads default value in order to obtain a better default performance out-of-the-box.

      Nowadays, many computers use SSD, or high-speed HDD, so default value, 4, is certainly low.
      It should be, in my opinion:

      • innodb_read_io_threads = 8
      • innodb_write_io_threads = 8

      And in the Windows / Linux MariaDB installer, just as innodb_buffer_pool_size is configured depending on the Server, this values shall be increased to:

      • innodb_read_io_threads = 16
      • innodb_write_io_threads = 16

      This is of special importance, as MariaDB uses from 10.2 engine InnoDB, and not XtraDB, and this is the bottleneck which prevents InnoDB having the same performance than XtraDB.

      Thank you,
      Juan

      Attachments

        Activity

          People

            Unassigned Unassigned
            Juan Juan Telleria
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.