I am trying to set the optimizer switch block nested loop off in my.cnf. I have tried several different ways, but when I insert it in the [MYSQLD] stanza, the db process on the node will not start. When I remove it, it starts fine. Can anyone tell me how I can set this option in the my.cnf file?
You will find an example of this variable usage in the configuration file here: