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

server stall on sync index (insert into large innodb table with fulltext index)

    XMLWordPrintable

Details

    • 10.0.26

    Description

      I encounter exactly the same issue as described in this mysql bug
      http://bugs.mysql.com/bug.php?id=73816
      "In an instance of ours, where we are using FULLTEXT indexes on InnoDB tables, we see occasional blocked DML operations on any table using any engine (InnoDB as well as MyISAM) for the duration of ~2 minutes. The SHOW INNODB STATUS reveals that the oldest running transaction is an INSERT into a table with a FULLTEXT index"

      As mariadb doesn't have the parameter binlog_order_commits the only workaround found so far was to disable binary logging.

      Attachments

        1. innodb_status_2016-09-08_0926.txt
          38 kB
          David Schnall
        2. innodb_status_2016-09-08_0929.txt
          39 kB
          David Schnall
        3. innodb_status_2016-09-08_0936.txt
          38 kB
          David Schnall
        4. sync.test
          5 kB
          Elena Stepanova

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              dschnall David Schnall
              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.