mysql 8核16g参数优化_问个 MySql 优化问题, 16G, 8 核服务器??

服务器配置:

处理器:Xeon E3-1230 V2

内存:16G DDR3 1600Mhz

硬盘:1TB 企业级硬盘

我现在的配置

[mysqld]

port= xxxx

socket= xxx

datadir = xxxx

default_storage_engine = MyISAM

#skip-external-locking

#loose-skip-innodb

key_buffer_size = 2048M

max_allowed_packet = 100G

table_open_cache = 1024

sort_buffer_size = 4M

net_buffer_length = 4K

read_buffer_size = 4M

read_rnd_buffer_size = 256K

myisam_sort_buffer_size = 64M

thread_cache_size = 128

query_cache_size = 128M

tmp_table_size = 128M

#skip-networking

#skip-name-resolve

max_connections = 3000

max_connect_errors = 600

open_files_limit = 65535

log-bin=mysql-bin

binlog_format=mixed

server-id= 1

expire_logs_days = 10

default_storage_engine = InnoDB

innodb_data_home_dir = xxxxx

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir =xxxxx

innodb_buffer_pool_size = 1024M

innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 256M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 500

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 256M

sort_buffer_size = 4M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

请问如何优化一下呢,数据库读写量大。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值