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

ADD FULLTEXT INDEX CAUSES SYSTEM SLOWDOWN

    XMLWordPrintable

Details

    Description

      Hello,

      I hope everyone is okay.

      ALTER TABLE [TABLE_NAME] ADD FULLTEXT INDEX [INDEX]

      This is causing a degradation of the operating system, crashing windows to the point of needing to restart the computer.

      This also happens with versions older than MySql 8 (like mysql 5.7, 5.6), but not in mysql 8.

      The table in question contains a few megabytes of data and field datatype is LONGTEXT. When creating the fulltext index (ALTER TABLE tbl_documentos_comp ADD FULLTEXT INDEX C_IND_20 (C_OCR);), MariaDB does not respect the limit of the innodb_buffer_pool_size variable and increases memory consumption progressively without stopping.

      With 100% memory spikes, the operating system is slow and the computer crashes.

      Please download dump file:
      https://drive.google.com/file/d/1_IYgC9_ls0f1nlPBlP7YX8RQSMf_S4JJ/view?usp=sharing

      Regards!

      Attachments

        1. my.ini
          1 kB
        2. system.png
          system.png
          20 kB
        3. table.png
          table.png
          23 kB
        4. tables.png
          tables.png
          19 kB

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            MIRANDA JOSEFH
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.