MySQL Bugs: #24084: Options named inconsistently in show status and my.cnf

Bug #24084	Options named inconsistently in show status and my.cnf
Submitted:	8 Nov 2006 12:14	Modified:	10 Nov 2006 13:33
Reporter:	Kristian Koehntopp	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: General	Severity:	S4 (Feature request)
Version:	all	OS:	Any (all)
Assigned to:		CPU Architecture:	Any
Tags:	option naming

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
SHOW STATUS is reporting 'locked_in_memory', but in the config it is set with 'memlock' which is completely inconsistent.

SHOW STATUS is reporting myisam_recovery_options, but in the config it is set with myisam_recover, which is again inconsistent.

How to repeat:
Read the manual and try:

[mysqld]
locked_in_memory
myisam_recovery_options = FORCE,BACKUP

does not work.

SHOW STATUS LIKE "memlock" does report nothing.
SHOW STATUS LIKE "myisam_recover" does report nothing.

Suggested fix:
Unify this by changing the option names, but allow the old traditional option names for a release or so as deprecated.

Thank you for a reasonable feature request.