Trying to set optimizer_switch block_nested_loop=off in my.cnf in 5.7

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?

1 Like

You will find an example of this variable usage in the configuration file here:
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html

1 Like