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

mysqldump --tab --header is slow

Details

    Description

      mysqldump --header --tab wraps the dumping SELECT in UNION ALL + ORDER BY. Which means a filesort (try EXPLAIN), that would make mysqldump notably slower on large tables. This is completely unnecessary, because the ordering of table rows is unimportant.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-22200 mysqldump client: --tab export with column names header row

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-12879 Please add support for exporting column headers to CSV

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            Transition Time In Source Status Execution Times
            Daniel Black made transition -
            Open In Progress
            		7h 58m 1
            Daniel Black made transition -
            In Progress In Review
            		35s 1
            Sergei Golubchik made transition -
            In Review Stalled
            		62d 13h 16m 1
            Daniel Black made transition -
            Stalled Closed
            		5d 14h 56m 1

            People

              danblack Daniel Black
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.