mysql 提高电脑配置_生产环境4G内存云主机 MariaDB/MySQL数据库my.cnf配置文件 - 老牛博客...

[client]

#password   = your_password

port        = 3306

socket      = /tmp/mysql.sock

[mysqld]

port        = 3306

socket      = /tmp/mysql.sock

user    = mariadb

basedir = 这里是你自己的路径(查安装后的默认配置文件)

datadir = 这里是你自己的路径(查安装后的默认配置文件)

log_error = 这里是你自己的路径(查安装后的默认配置文件)

pid-file = 这里是你自己的路径(查安装后的默认配置文件)

back_log = 384

bulk_insert_buffer_size = 8M

connect_timeout = 10

group_concat_max_len = 1024

join_buffer_size = 128K

key_buffer_size = 1344M

max-allowed-packet = 64M

max-connect-errors = 1000000

max_length_for_sort_data = 1024

max_connections = 500

max_heap_table_size = 256M

myisam-recover-options = FORCE,BACKUP

myisam_sort_buffer_size = 256M

myisam_max_sort_file_size = 1024M

net_buffer_length = 16384

open_files_limit = 65535

query_cache_type= 1

query_cache_size = 128M

query_cache_limit = 512K

query_cache_min_res_unit = 2K

query_prealloc_size = 262144

query_alloc_block_size = 65536

read_buffer_size = 256K

read_rnd_buffer_size = 512K

sort_buffer_size = 256K

skip-name-resolve

skip-external-locking

tmp_table_size = 256M

transaction_alloc_block_size = 8192

transaction_prealloc_size = 4096

thread_cache_size = 256

table-definition-cache = 2048

table_open_cache = 2048

thread_concurrency = 8

wait_timeout = 1800

log-bin=mysql-bin

binlog_format=mixed

server-id   = 1

expire_logs_days = 7

default_storage_engine = InnoDB

innodb_file_per_table = 1

innodb_data_home_dir = /mnt/mariadb/var

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /mnt/mariadb/var

#default innodb_buffer_pool_size = 128M

innodb_buffer_pool_size = 128M

innodb_log_file_size = 32M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

[mysqldump]

quick

max_allowed_packet = 32M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout