注意:部分文章发布时间较长,可能存在未知因素,购买时建议在本站搜索商家名称,先充分了解商家动态。
交流:唯一投稿邮箱:hostvps@88.com。
网友 **约吗 说:
WP 程序,同一个网站,放在WIN和linxu里,同样配置的,WIN 2008 mys*l占用CPU 100%, LINUX debian mys*l占用大约40%-70%
具体配置KS-LE E5-1650v2/32G/2x4TB
mys*l 5.6.5
linux的mys*l配置文件内容
[client]
#pa**word = yo**_pa**word
port = 3306
socket = /tmp/mys*l.sock
[mys*ld]
binlog_cache_size = 2560K
thread_stack = 5120K
join_buffer_size = 8192K
*uery_cache_type = 1
max_heap_table_size = 1024M
port = 3306
socket = /tmp/mys*l.sock
datadir = /www/******/data
def**lt_storage_engine = InnoDB
performance_schema_max_table_instances = 400
table_definition_cache = 400
skip-external-locking
key_buffer_size = 1024M
max_allowed_packet = 100G
table_open_cache = 1024
sort_buffer_size = 1024K
net_buffer_len*** = 4K
read_buffer_size = 1024K
read_rnd_buffer_size = 8048K
myisam_sort_buffer_size = 128M
thread_cache_size = 2560
*uery_cache_size = 1024M
tmp_table_size = 1024M
s*l-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_*****S
explicit_def**lts_for_timestamp = true
#skip-name-resolve
max_connections = 500
max_connect_er**rs = 100
open_files_limit = 65535
log-bin=mys*l-bin
binlog_format=mixed
******-id = 1
expire_logs_days = 10
slow_*uery_log=1
slow-*uery-log-file=/www/******/data/mys*l-slow.log
long_*uery_time=3
#log_*ue**es_not_using_indexes=on
innodb_data_home_dir = /www/******/data
innodb_data_file_path = ibdata1:10M:**toextend
innodb_log_g**up_home_dir = /www/******/data
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 1024M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_max_dirty_pages_pct = 90
innodb_read_io_threads = 8
innodb_w**te_io_threads = 8
[mys*ldump]
*uick
max_allowed_packet = 500M
[mys*l]
no-**to-rehash
[myisamchk]
key_buffer_size = 512M
sort_buffer_size = 8M
read_buffer = 2M
w**te_buffer = 2M
[mys*lhotcopy]
interactive-timeout