[MDEV-19116] Speed up rotation of binary logs - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.4.4
Component/s: Replication
Labels:
None

Description

Speed up rotation of binary logs when there are 10,000 logs

The problem is that find_uniq_filename() for each creating of a new binary log file reads all files from the directory, which can take a long time if there are a lot of binary log files.

Fix is to cache the last used log name number and reuse that for future calls.

Attachments

Issue Links

is duplicated by

MDEV-18614 Optimization for binlog rotation

Closed

Activity

Ascending order - Click to sort in descending order

Michael Widenius created issue - 2019-04-01 12:21

Sergei Golubchik made changes - 2019-04-01 19:16

Field	Original Value	New Value
Fix Version/s		10.4 [ 22408 ]
Fix Version/s	10.4.4 [ 23310 ]

Michael Widenius made changes - 2019-04-02 13:18

Assignee

Michael Widenius [ monty ]

Michael Widenius added a comment - 2019-04-02 13:19

Pushed

Michael Widenius added a comment - 2019-04-02 13:19 Pushed

Michael Widenius made changes - 2019-04-02 13:19

issue.field.resolutiondate

2019-04-02 13:19:08.0

2019-04-02 13:19:08.483

Michael Widenius made changes - 2019-04-02 13:19

Fix Version/s		10.4.4 [ 23310 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:24

Workflow

MariaDB v3 [ 94136 ]

MariaDB v4 [ 133909 ]

Michael Widenius made changes - 2023-11-17 14:35

Link

This issue is duplicated by ~~MDEV-18614~~ [ ~~MDEV-18614~~ ]

People

Assignee:: Michael Widenius

Reporter:: Michael Widenius

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Due:: 2019-04-01

Created:: 2019-04-01 12:21

Updated:: 2023-11-17 14:35

Resolved:: 2019-04-02 13:19

Git Integration

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

MariaDB Server