服務器配置：

處理器：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

請問如何優化一下呢，數據庫讀寫量大。

總結

以上是生活随笔為你收集整理的mysql 8核16g参数优化_问个 MySql 优化问题， 16G， 8 核服务器??的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。