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)

    Details

    • Sprint:
      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

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                dschnall David Schnall
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: