Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Do not delete ib_logfile0 on MariaDB 10.8.1 or higher #546

Open
pfrenssen opened this issue Jul 2, 2024 · 2 comments
Open

Do not delete ib_logfile0 on MariaDB 10.8.1 or higher #546

pfrenssen opened this issue Jul 2, 2024 · 2 comments

Comments

@pfrenssen
Copy link

Starting with MariaDB 10.8.1 the ib_logfile0 is required and should not be deleted (ref. MDEV-27199: Require ib_logfile0 to exist.

@geerlingguy
Copy link
Owner

- name: Delete innodb log files created by apt package after initial install.
ansible.builtin.file:
path: "{{ mysql_datadir }}/{{ item }}"
state: absent
with_items:
- ib_logfile0
- ib_logfile1
when: >
not mysql_installed.stat.exists
and ansible_distribution_major_version | int < 12
- what about logfile1?

@pfrenssen
Copy link
Author

logfile1 is seemingly already obsolete in MariaDB since 10.5.0. In that version they switched to using 1 single log file. I found the ticket: MDEV-20907: Set innodb_log_files_in_group=1 by default.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants