mysql8 参数调优mysql8内存优化配置

导读服务器配置：阿里云：windows2008server2核8G，运行mysql和tomcat服务，接下来我们就来聊聊关于mysql8参数调优?以下内容大家不....

服务器配置：阿里云：windows 2008 server 2核8G，运行mysql和tomcat服务，接下来我们就来聊聊关于mysql8 参数调优?以下内容大家不妨参考一二希望能帮到您!

mysql8 参数调优

服务器配置：

阿里云：windows 2008 server 2核8G，运行mysql和tomcat服务

my.ini配置如下，欢迎指正。

# Other default tuning values

# MySQL Server Instance Configuration File

# ----------------------------------------------------------------------

# Generated by the MySQL Server Instance Configuration Wizard

#

#

# Installation Instructions

# ----------------------------------------------------------------------

#

# On Linux you can copy this file to /etc/my.cnf to set global options,

# mysql-data-dir/my.cnf to set server-specific options

# (@localstatedir@ for this installation) or to

# ~/.my.cnf to set user-specific options.

#

# On Windows you should keep this file in the installation directory

# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To

# make sure the server reads the config file use the startup option

# "--defaults-file".

#

# To run the server from the command line, execute this in a