1.轻量配置

[client]

port=3306

default-character-set=utf8mb4

[mysql]

default-character-set=utf8mb4

[mysqld]

port=3306

server_id=1

basedir="{up-path}Modules/MySQL/"

datadir="{up-path}Database/data_mysql/"

tmpdir="{up-path}Temp/mysql/"

log-error="{up-path}Logs/mysql.log"

slow-query-log-file="{up-path}Logs/mysql_slow_query.log"

secure-file-priv="{up-path}Modules/MySQL/uploads"

character-set-client-handshake=FALSE

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

default-storage-engine=MYISAM

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

explicit_defaults_for_timestamp=true

interactive_timeout=120

wait_timeout=120

log_error_verbosity=1

slow_query_log=0

long_query_time=2

local-infile=0

skip-external-locking

skip-ssl

#skip-name-resolve

#skip-networking

#enable-named-pipe

#bind-address=127.0.0.1

#log-bin=mysql-bin

#binlog_format=mixed

max_connections=100

query_cache_size=0

performance_schema_max_table_instances=600

table_definition_cache=400

key_buffer_size=32M

sort_buffer_size=256kb

read_buffer_size=512kb

join_buffer_size=1M

read_rnd_buffer_size=2M

max_allowed_packet=16M

table_open_cache=128

tmp_table_size=32M

max_heap_table_size=32M

thread_cache_size=8

myisam_max_sort_file_size=64G

myisam_sort_buffer_size=8M

innodb_buffer_pool_size=64M

innodb_log_file_size=256M

innodb_log_buffer_size=4M

innodb_file_per_table=1

innodb_flush_log_at_trx_commit=1

innodb_flush_method=normal

innodb_thread_concurrency=0

innodb_lock_wait_timeout=120

[mysqldump]

quick

max_allowed_packet=16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size=10M

sort_buffer_size=10M

read_buffer_size=1M

write_buffer_size=1M

tmpdir="{up-path}Temp/mysql/"

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

open-files-limit=8192

2.均衡配置

[client]

port=3306

default-character-set=utf8mb4

[mysql]

default-character-set=utf8mb4

[mysqld]

port=3306

server_id=1

basedir="{up-path}Modules/MySQL/"

datadir="{up-path}Database/data_mysql/"

tmpdir="{up-path}Temp/mysql/"

log-error="{up-path}Logs/mysql.log"

slow-query-log-file="{up-path}Logs/mysql_slow_query.log"

secure-file-priv="{up-path}Modules/MySQL/uploads"

character-set-client-handshake=FALSE

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

default-storage-engine=MYISAM

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

explicit_defaults_for_timestamp=true

interactive_timeout=120

wait_timeout=120

log_error_verbosity=1

slow_query_log=0

long_query_time=2

local-infile=0

skip-external-locking

skip-ssl

#skip-name-resolve

#skip-networking

#enable-named-pipe

#bind-address=127.0.0.1

#log-bin=mysql-bin

#binlog_format=mixed

max_connections=300

query_cache_size=0

performance_schema_max_table_instances=600

table_definition_cache=400

key_buffer_size=64M

sort_buffer_size=512kb

read_buffer_size=1M

join_buffer_size=2M

read_rnd_buffer_size=4M

max_allowed_packet=16M

table_open_cache=256

tmp_table_size=64M

max_heap_table_size=64M

thread_cache_size=16

myisam_max_sort_file_size=64G

myisam_sort_buffer_size=32M

innodb_buffer_pool_size=128M

innodb_log_file_size=256M

innodb_log_buffer_size=8M

innodb_file_per_table=1

innodb_flush_log_at_trx_commit=1

innodb_flush_method=normal

innodb_thread_concurrency=0

innodb_lock_wait_timeout=120

[mysqldump]

quick

max_allowed_packet=16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size=20M

sort_buffer_size=20M

read_buffer_size=2M

write_buffer_size=2M

tmpdir="{up-path}Temp/mysql/"

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

open-files-limit=8192

3.高端配置

[client]

port=3306

default-character-set=utf8mb4

[mysql]

default-character-set=utf8mb4

[mysqld]

port=3306

server_id=1

basedir="{up-path}Modules/MySQL/"

datadir="{up-path}Database/data_mysql/"

tmpdir="{up-path}Temp/mysql/"

log-error="{up-path}Logs/mysql.log"

slow-query-log-file="{up-path}Logs/mysql_slow_query.log"

secure-file-priv="{up-path}Modules/MySQL/uploads"

character-set-client-handshake=FALSE

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

default-storage-engine=MYISAM

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

explicit_defaults_for_timestamp=true

interactive_timeout=120

wait_timeout=120

log_error_verbosity=1

slow_query_log=0

long_query_time=2

local-infile=0

skip-external-locking

skip-ssl

#skip-name-resolve

#skip-networking

#enable-named-pipe

#bind-address=127.0.0.1

#log-bin=mysql-bin

#binlog_format=mixed

max_connections=600

query_cache_size=0

performance_schema_max_table_instances=600

table_definition_cache=400

key_buffer_size=256M

sort_buffer_size=1M

read_buffer_size=2M

join_buffer_size=4M

read_rnd_buffer_size=4M

max_allowed_packet=16M

table_open_cache=512

tmp_table_size=128M

max_heap_table_size=128M

thread_cache_size=32

myisam_max_sort_file_size=64G

myisam_sort_buffer_size=64M

innodb_buffer_pool_size=256M

innodb_log_file_size=256M

innodb_log_buffer_size=16M

innodb_file_per_table=1

innodb_flush_log_at_trx_commit=1

innodb_flush_method=normal

innodb_thread_concurrency=0

innodb_lock_wait_timeout=120

[mysqldump]

quick

max_allowed_packet=16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size=40M

sort_buffer_size=40M

read_buffer_size=4M

write_buffer_size=4M

tmpdir="{up-path}Temp/mysql/"

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

open-files-limit=8192

4.极限配置

[client]

port=3306

default-character-set=utf8mb4

[mysql]

default-character-set=utf8mb4

[mysqld]

port=3306

server_id=1

basedir="{up-path}Modules/MySQL/"

datadir="{up-path}Database/data_mysql/"

tmpdir="{up-path}Temp/mysql/"

log-error="{up-path}Logs/mysql.log"

slow-query-log-file="{up-path}Logs/mysql_slow_query.log"

secure-file-priv="{up-path}Modules/MySQL/uploads"

character-set-client-handshake=FALSE

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

default-storage-engine=MYISAM

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

explicit_defaults_for_timestamp=true

interactive_timeout=120

wait_timeout=120

log_error_verbosity=1

slow_query_log=0

long_query_time=2

local-infile=0

skip-external-locking

skip-ssl

#skip-name-resolve

#skip-networking

#enable-named-pipe

#bind-address=127.0.0.1

#log-bin=mysql-bin

#binlog_format=mixed

max_connections=1000

query_cache_size=0

performance_schema_max_table_instances=600

table_definition_cache=400

key_buffer_size=512M

sort_buffer_size=1M

read_buffer_size=4M

join_buffer_size=8M

read_rnd_buffer_size=8M

max_allowed_packet=16M

table_open_cache=1024

tmp_table_size=256M

max_heap_table_size=256M

thread_cache_size=64

myisam_max_sort_file_size=64G

myisam_sort_buffer_size=128M

innodb_buffer_pool_size=512M

innodb_log_file_size=256M

innodb_log_buffer_size=16M

innodb_file_per_table=1

innodb_flush_log_at_trx_commit=1

innodb_flush_method=normal

innodb_thread_concurrency=0

innodb_lock_wait_timeout=120

[mysqldump]

quick

max_allowed_packet=16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size=80M

sort_buffer_size=80M

read_buffer_size=8M

write_buffer_size=8M

tmpdir="{up-path}Temp/mysql/"

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

open-files-limit=8192

本文链接：https://my.lmcjl.com/post/18762.html