如何启用MySQL 8 innodb_dedicated_server选项

Question

最初，我在寻找调谐 -- MySql 8实例--然后我发现在第8版中添加了类似于自动配置的特性。然后我访问了官方的MySQL 文档网站，发现了这个，但我无法理解这一点。

正如官方文档中给出的，当启用此选项时，MySql会自动配置某些缓存和黄油选项，这样我就不必在缩放服务器实例时更改配置。

当我试图将innodb_dedicated_server = ON添加到my.cnf和mysqld.cnf时，它导致无法启动服务器。

在/var/log/mysql/error.log中一无所获，并通过日志-xe找到

Jan 08 17:41:50 fa-b2b-mysql mysql-systemd-start[31493]: Once the problem is resolved, restart the service.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: mysql.service: Control process exited, code=exited status=1
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Unit mysql.service has failed.
-- 
-- The result is RESULT.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Automatic restarting of the unit mysql.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Unit mysql.service has finished shutting down.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: mysql.service: Start request repeated too quickly.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 08 17:41:50 fa-b2b-mysql systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Unit mysql.service has failed.
-- 
-- The result is RESULT.

Answer 1

(我写了一篇关于那个文档页的错误报告。)

您没有在机器上运行任何其他应用程序(Apache、Java等)，对吗？

计划A:手动使用innodb_buffer_pool_size = 1200M，我认为2G对于4G内存来说太大了。

计划B:写一份错误报告。其中提供了您的整个my.cnf和您正在使用的确切版本(bugs.mysql.com)。然后放弃innodb_dedicated_server = ON。