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

wsrep_streaming_log file size continues to grow

    XMLWordPrintable

    Details

      Description

      It is observed that the system table "mysql.wsrep_streaming_log" file size continues to grow when loading a large amount of data. After restarting the DB server, the file size still remains. It needs to optimize the table in order to clean up the file size.

      To repeat the scenario:

      1. In DB server:
      set global wsrep_trx_fragment_size=1073741823;
      2. Create a table.
      3. Record the table file size of mysql/wsrep_streaming_log.ibd in mydata directory.
      4. Load data to the table within a single transaction having total data size <= 1073741823.
      5. Record the table file size of mysql/wsrep_streaming_log.ibd again, the size grows accordingly.
      6. Restart the DB server, the file size does not decrease.
      7. Run optimize the table, the file size decrease.

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            ktchow_ogcio Chow King Tak
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.