牛转钱坤
鼠年大吉»
评论:
李丹
2021-10-11 10:33
2021-10-11 10:33
[mysqld]
port= 3306
character-set-server = gbk
default-storage-engine = INNODB
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 16M
innodb_strict_mode = 0
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 200M
max_connections = 800
lower_case_table_names = 1
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 32M
gtid_mode = off
enforce_gtid_consistency = 0
validate-password = off
default-time-zone = '+8:00'
[mysqldump]
quick
max_allowed_packet = 200M
[mysql]
no-auto-rehash
default_character_set = gbk
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
port= 3306
character-set-server = gbk
default-storage-engine = INNODB
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 16M
innodb_strict_mode = 0
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 200M
max_connections = 800
lower_case_table_names = 1
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 32M
gtid_mode = off
enforce_gtid_consistency = 0
validate-password = off
default-time-zone = '+8:00'
[mysqldump]
quick
max_allowed_packet = 200M
[mysql]
no-auto-rehash
default_character_set = gbk
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
2022-09-05 22:22