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

alter table engine=blackhole takes lot of time

    XMLWordPrintable

Details

    Description

      I decided to alter big myisam tables to blackhole and it took very long, like if it was converting to any other type

      Example:
      Query OK, 201147303 rows affected (8 min 9.60 sec)
      Records: 201147303 Duplicates: 0 Warnings: 0

      Actually I could make it faster by either dropping/recreating or truncating/alter

      Maybe a small fix can be introduced? To make alter-to-blackhole happen faster regardless the original table size/engine?

      Thanks!

      Attachments

        Activity

          People

            serg Sergei Golubchik
            ShivaS Alex
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.