|
|
这我自己找网上教程设置,看看行不.
skip-external-locking
back_log = 384
max_connections = 36000
max_connect_errors = 10
table_open_cache = 8192
max_allowed_packet = 32M
binlog_cache_size = 8M
max_heap_table_size = 2048M
read_buffer_size = 256M
read_rnd_buffer_size = 128M
sort_buffer_size = 256M
join_buffer_size = 256M
thread_cache_size = 2048
thread_concurrency = 64
query_cache_size = 2048M
query_cache_limit = 32M
ft_min_word_len = 4
default-storage-engine = MYISAM
thread_stack = 1024K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 8192M
#log-bin=mysql-bin
#binlog_format=mixed
#server-id = 1
key_buffer_size = 36000M
bulk_insert_buffer_size = 256M
myisam_sort_buffer_size = 256M
myisam_max_sort_file_size = 40G
myisam_repair_threads = 1
myisam_recover
innodb_additional_mem_pool_size = 128M
innodb_buffer_pool_size = 40G
innodb_data_file_path = ibdata1:4092M:autoextend
innodb_file_io_threads = 64
innodb_thread_concurrency = 64
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 32M
innodb_log_file_size = 256M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 60
[mysqldump]
quick
max_allowed_packet = 16M
|
|
发表于 2018-4-27 10:46:34
楼主
，那就看些mysql dba 视频吧，我也不是太会，反正别瞎改，自己起码知道大概是什么东西，会影响什么，就可以下手了