Not the answer you need?
Register and ask your own question!

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

kaybeekaybee EntrantCurrent User Role Novice
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?


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.