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

Flush the DDL log on FLUSH LOGS

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      When ALTER TABLE is executed, some (rollback?) metadata is written to a DDL log file in the datadir. This file cannot be rotated on-the-fly - only a restart of the mysqld allows it to be deleted. On systems which make a heavy use of ALTER TABLE the log file easily reaches gigabytes within days. The DDL log was first seen on Oracle MySQL 5.7.

      This request asks for a change in behaviour so that the FLUSH LOGS statement will apply to the DDL log also in the same was as it does to binary logs et al.

      Attachments

        Activity

          People

            ralf.gebhardt Ralf Gebhardt
            assen.totin Assen Totin (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.