[MDEV-6812] Merge Kakao: Add global status variables which tell you the progress of inplace alter table and row log buffer usage Created: 2014-09-30  Updated: 2019-05-28  Resolved: 2014-09-30

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Fix Version/s: 10.1.1

Type: Task Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: innodb, xtradb

Issue Links:
Problem/Incident
causes MDEV-12625 total_index_blocks is uninitialized i... Closed
Relates
relates to MDEV-12512 Accurately report progress for ALTER ... Open
relates to MDEV-10509 Excessive InnoDB logging on release s... Closed

 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.

 Comments   
Comment by Jan Lindström (Inactive) [ 2014-09-30 ]

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

Comment by Jan Lindström (Inactive) [ 2014-09-30 ]

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()

Comment by Jan Lindström (Inactive) [ 2014-09-30 ]

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.
Generated at Thu Feb 08 07:14:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.