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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                jplindst Jan Lindström 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

                Show
                jplindst Jan Lindström 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
                Hide
                Permalink
                jplindst Jan Lindström 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()

                Show
                jplindst Jan Lindström 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()
                Hide
                Permalink
                jplindst Jan Lindström 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.
                Show
                jplindst Jan Lindström 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.

                  People

                  • Assignee:
                    jplindst Jan Lindström
                    Reporter:
                    jplindst Jan Lindström
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: