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

EITS could eat all tmpdir space and hang

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.10
    • 10.0.13
    • None
    • None

    Description

      Hi,

      While testing the EIST feature, I tried to analyze a 24GB table with use_stat_tables='preferably'. It ended up with a full tmpdir without any warnings from MariaDB. (and a stuck ANALYZE TABLE command).

      I would have expected MariaDB to respect the tmp_table_size value while trying to compute the statistics ?

      Thanks and regards,
      Jocelyn Fournier

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-6529 optimize VARCHAR temp storage during EITS ANALYZE

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Technical task - A technical task. MDEV-21580 Allow packed sort keys in sort buffer

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21829 Use packed sort keys in Unique objects

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open In Progress
            		99d 1h 44m 1
            Sergei Golubchik made transition -
            In Progress Closed
            		18h 44m 1

            People

              serg Sergei Golubchik
              jocel1 jocelyn fournier
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.