I’ve run into this a lot and I would appreciate some clarification. For instance, in the default my.cnf file, there is this option:
default_storage_engine = InnoDB
Then in the config I got from the Percona Wizard, there is this:
default-storage-engine = InnoDB
Now in this instance, the 5.x docs don’t show the first one, but for other names where I run into the same “dashes vs underscores” confusion, it lists the one with dashes as the Option-File Format and the underscores as the System Variable Name. I find them mixed all the time and just don’t understand. I want to be consistent and correct. What is the difference between System Variable Name and Option-File Format in this context, and what should I be using in my.cnf? I could just assume the latter is correct and stick with that but then why is the default file using the former? And in this case, it’s using a format that isn’t even in the docs. If someone could clear this up, I would really appreciate it.