不灭的焱

革命尚未成功,同志仍须努力

作者:php-note.com  发布于:2020-08-26 14:07  分类:MySQL/NoSQL  编辑

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