mysql优化my.ini

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/iteye_1960/article/details/81896217

服务器2GB内存,MySql优化my.ini

 

[client]
port=3306

[mysql]
default-character-set=utf8

[mysqld]
bind-address=0.0.0.0
basedir=/usr/
datadir=/var/lib/mysql/
default-character-set=utf8
max_connections=1000
query_cache_size=64M
query_cache_min_res_unit=6
query_alloc_block_size=1128M
key_cache_block_size=2048
tmp_table_size=32M
thread_cache_size=8
key_buffer_size=512M
read_buffer_size=4096K
sort_buffer_size=64M
innodb_additional_mem_pool_size=256M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=4M
innodb_buffer_pool_size=500M
innodb_doublewrite=0
innodb_log_file_size=100M
innodb_thread_concurrency=8
innodb_lock_wait_timeout=10
wait_timeout=10
back_log=80
table_cache=256M
table_open_cache=128M
binlog_cache_size=20M

[mysqldump]
quick
max_allowed_packet=256M

 

展开阅读全文

没有更多推荐了,返回首页