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

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

            Ascending order - Click to sort in descending order
            jplindst Jan Lindström (Inactive) created issue -
            jplindst Jan Lindström (Inactive) made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) added a comment -

            See: http://kakao-dbe.blogspot.kr/2014/09/mysql-status-variables-for-innodb.html and http://seonguck.blogspot.kr/2014/09/what-is-problem-of-mysql-online-ddl.html

            jplindst Jan Lindström (Inactive) added a comment - See: http://kakao-dbe.blogspot.kr/2014/09/mysql-status-variables-for-innodb.html and http://seonguck.blogspot.kr/2014/09/what-is-problem-of-mysql-online-ddl.html
            jplindst Jan Lindström (Inactive) added a comment -

            In final merge I will not use sql_print_warning(); because that will produce several unnecessary test failures : Found warnings/errors in server log file! in mtr testing. Instead of sql_print_warning() we use sql_print_information()

            jplindst Jan Lindström (Inactive) added a comment - In final merge I will not use sql_print_warning(); because that will produce several unnecessary test failures : Found warnings/errors in server log file! in mtr testing. Instead of sql_print_warning() we use sql_print_information()
            jplindst Jan Lindström (Inactive) added a comment -

            commit fc2df3c637d51c4ab32132e2d8f63dbe7e80f056
            Author: Jan Lindström <jan.lindstrom@skysql.com>
            Date: Tue Sep 30 14:50:34 2014 +0300

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

            • (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 me
              ans 100.00% ).
            • Innodb_onlineddl_pct_progress
              Shows the progress of inplace alter table. It might
              be not so accurate because 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.
            jplindst Jan Lindström (Inactive) added a comment - commit fc2df3c637d51c4ab32132e2d8f63dbe7e80f056 Author: Jan Lindström <jan.lindstrom@skysql.com> Date: Tue Sep 30 14:50:34 2014 +0300 MDEV-6812 : Merge Kakao: Add global status variables which tell you the progress of inplace alter table and row log buffer usage (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 me ans 100.00% ). Innodb_onlineddl_pct_progress Shows the progress of inplace alter table. It might be not so accurate because 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.
            jplindst Jan Lindström (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 55055 ] MariaDB v3 [ 61521 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 61521 ] MariaDB v4 [ 132419 ]

            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.