midoks / mdserver-mac

mdserver (mac version, secondary development)
https://www.cachecha.com
MIT License
189 stars 29 forks source link

mysql启动失败 [ERROR] unknown variable 'thread_concurrency=8' #22

Closed 1099438829 closed 4 years ago

1099438829 commented 4 years ago

错误log:

2020-02-07T14:29:58.807339Z 0 [Note] InnoDB: Loading buffer pool(s) from /Applications/mdserver/bin/mysql/data/ib_buffer_pool 2020-02-07T14:29:58.807510Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-02-07T14:29:58.808119Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200207 22:29:58 2020-02-07T14:29:58.814009Z 0 [ERROR] unknown variable 'thread_concurrency=8'

修改建议: 经我测试为 mdserver 自带的reinstall/tpl/mysql/my.cnf 使用了旧的配置导致的,屏蔽或删除即可

skykain commented 4 years ago

我这边测试下,好像与 reinstall/tpl/mysql/my.cnf 这文件没关系了 启动 Mysql 好像用的是 bin/tmp/my.cnf 文件,屏蔽 'thread_concurrency=8' 后,可以正常启动 但在界面上按 [start] 按键后,bin/tmp/my.cnf 此文件又会被重置 ,导致 Mysql 下次又不能启动

midoks commented 4 years ago

最好把reinstall/tpl/mysql/my.cnf修改为正确的就行了。如果点击菜单CMD->mysql->Install: reinstall/tpl/mysql/my.cnf 会覆盖 tmp/my.cnf