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

MySQL & MariaDB Other MySQL® Questions
1

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
2

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

1 Like