[MDEV-19954] Flush the DDL log on FLUSH LOGS Created: 2019-07-04 Updated: 2020-02-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Assen Totin (Inactive) | Assignee: | Ralf Gebhardt |
| Resolution: | Unresolved | Votes: | 3 |
| Labels: | 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. |