mysql服务器优化配置文件
时间：2021-07-01 10:21:17
帮助过：2人阅读
=/
var/lib/
mysql
socket=/
var/lib/mysql/
mysql.sock
user=
mysql
# Disabling symbolic-links
is recommended to prevent assorted security risks
symbolic-links=
0
[mysqld_safe]
log-error=/
var/log/
mysqld.log
pid-file=/
var/run/mysqld/
mysqld.pid
back_log=
600
max_connections=
3000
max_connect_errors=
6000
table_cache=
614
external-locking=
FALSE
max_allowed_packet=
32M
sort_buffer_size=
2M
join_buffer_size=
2M
thread_cache_size=
300
thread_concurrency=
8
query_cache_size=
64M
query_cache_limit=
4M
query_cache_min_res_unit=
2k
thread_stack=
192K
transaction_isolation=READ-
COMMITTED
tmp_table_size=
256M
max_heap_table_size=
256M
long_query_time=
2
expire_logs_days=
7
key_buffer_size=
2048M
read_buffer_size=
1M
read_rnd_buffer_size=
16M
bulk_insert_buffer_size=
64M
innodb_additional_mem_pool_size=
16M
innodb_buffer_pool_size=
2048M
innodb_data_file_path=
ibdata1:1024M:autoextend
innodb_file_io_threads=
4
innodb_thread_concurrency=
8
innodb_flush_log_at_trx_commit=
2
innodb_log_file_size=
128M
innodb_log_files_in_group=
3
innodb_max_dirty_pages_pct=
90
innodb_lock_wait_timeout=
120
innodb_file_per_table=
0
View Code
mysql服务器优化配置文件
标签：
