2 chenshuang com chenshuang_com 于 2016.09.19 13:19 提问

mysql 设置optimizer_switch属性值报错 50C

mysql> set optimizer_switch='mrr=on,mrr_cost_based=on,batched_key_access=on';
1231 - Variable 'optimizer_switch' can't be set to the value of 'mrr=on,mrr_cost_based=on,batched_key_access=on'
mysql>

2个回答

feng1790291543
feng1790291543   Ds   Rxr 2016.09.19 13:20
chenshuang_com
chenshuang_com   2016.09.19 13:23

还是报错,我用的mysql6.0版本的:
set global optimizer_switch='mrr=on,mrr_cost_based=on,batched_key_access=on';
1231 - Variable 'optimizer_switch' can't be set to the value of 'mrr=on,mrr_cost_based=on,batched_key_access=on'

Csdn user default icon
上传中...
上传图片
插入图片