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

Introduce debug option innodb_change_buffer_dump

    XMLWordPrintable

Details

    Description

      To diagnose a hang in slow shutdown (innodb_fast_shutdown=0), let us introduce a Boolean startup option in debug builds that will cause the contents of the InnoDB change buffer to be dumped to the server error log at startup, like this:

      2019-10-19 15:13:40 139865652927488 [Note] InnoDB: Dumping the change buffer
      PHYSICAL RECORD: n_fields 6; 1-byte offsets; info bits 0
       0: len 4; hex 00000004; asc     ;;
       1: len 1; hex 00; asc  ;;
       2: len 4; hex 00000010; asc     ;;
       3: len 16; hex 0000000102fe00010008860300048000; asc                 ;;
       4: len 1; hex 78; asc x;;
       5: len 4; hex 800017c3; asc     ;;
      PHYSICAL RECORD: n_fields 6; 1-byte offsets; info bits 0
       0: len 4; hex 00000004; asc     ;;
       1: len 1; hex 00; asc  ;;
       2: len 4; hex 00000010; asc     ;;
       3: len 16; hex 0031000102fe00010008860300048000; asc  1              ;;
       4: len 1; hex 78; asc x;;
       5: len 4; hex 800017f4; asc     ;;
      2019-10-19 15:13:40 139865652927488 [Note] InnoDB: Dumped the change buffer
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              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.