Bug #96207 Change the name of ib_logifle to something different
Submitted: 15 Jul 2019 10:58 Modified: 16 Jul 2019 8:04
Reporter: Iwo P Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:any, 8.0 OS:Any
Assigned to: CPU Architecture:Any

[15 Jul 2019 10:58] Iwo P
Description:
When hitting no space left on a device situation some less familiar with MySQL administrators tend to remove the InnoDB's redo log files, as the name include the word ``log``. 

It obviously is a fault of careless dbas, however, the consequences are terrible and awful.

While it looks like a silly request, PostgreSQL did the same move [1], to protect people from silly mistakes.

[1] https://www.postgresql.org/message-id/E1bxFLx-0008Rq-S5%40gemulon.postgresql.org

How to repeat:
-

Suggested fix:
Change the name of ib_logifle%u to something different, like ib_redo%u or ib_wal%u.
[15 Jul 2019 10:59] Iwo P
Typo
[16 Jul 2019 8:04] MySQL Verification Team
Hello Iwo P,

Thank you for the feature request!

regards,
Umesh