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

Change EXAMINED_ROWS in I_S.PROCESSLIST from INT to BIGINT UNSIGNED

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • N/A
    • N/A
    • None

    Description

      Currently the EXAMINED_ROWS column in INFORMATION_SCHEMA.PROCESSLIST is of type INT, so limited to 2^31, or about two billion max.

      When doing an UPDATE that requires a full table scan on a table with more than two billion rows, EXAMINED_ROWS value for that session goes up to 2147483647 but then stops at that value even though the query is still scanning more rows.

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              hholzgra Hartmut Holzgraefe
              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.