MySQL64g内存设置_128G内存_mysql配置参数

################################################################################

#DATE: 2011-02-02

#SITE: http://datastrangler.com

#DESCRIPTION: MySQL config 5.0.x, 5.1.x, 5.5.x

#RAM: 128GB RAM dedicated server

#Connections: 5000 connections

################################################################################

[mysqld_safe]

nice

=

-15

[client]

socket

=

/var/lib/mysql/mysql.sock

default-character-set  =

utf8

[mysqld]

## Charset and Collation

character-set-server  =

utf8

collation-server  =

utf8_general_ci

## Files

back_log  =

300

open-files-limit  = 8192

open-files  =

1024 port

=

3306

socket

=

/var/lib/mysql/mysql.sock

pid-file  =

/var/lib/mysql/mysql.pid

skip-external-locking

skip-name-resolve

## Logging

datadir =

/var/lib/mysql

relay_log =

mysql-relay-bin

relay_log_index =

mysql-relay-index

#log =

mysql-gen.log log_error =

mysql-error.err

log_warnings

log_bin =

mysql-bin

log_slow_queries =

mysql-slow.log

#log_queries_not_using_indexes

long_query_time  =

10 #default: 10

max_binlog_size  =

256M #max size for binlog before rolling

expire_logs_