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

Merge Kakao: Add global status variables which tell you the progress of inplace alter table and row log buffer usage

    XMLWordPrintable

Details

    Description

      • (x 100%, it's 4-digit. 10000 means 100.00%)
      • Innodb_onlineddl_rowlog_rows
        Shows how many rows are stored in row log buffer.
      • Innodb_onlineddl_rowlog_pct_used
        Shows row log buffer usage in percent ( *100%, it's 4-digit. 10000 means 100.00% ).
      • Innodb_onlineddl_pct_progress
        Shows the progress of inplace alter table. It might be not so accurate becuase inplace alter is highly depend on disk and buffer pool status.
        But still it is useful and better than nothing.
      • Add some log for inplace alter table
      • XtraDB/InnoDB will print some message before and after doing some task.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12625 total_index_blocks is uninitialized in ALTER TABLE…ALGORITHM=INPLACE of small tables

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12512 Accurately report progress for ALTER TABLE...ALGORITHM=INPLACE

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10509 Excessive InnoDB logging on release server

          • Major - Major loss of function.
          • Closed

          Activity

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.