[mysql@st2-cloudpos-14 mysql]$ cat my-pos.cnf 

[client]

port            = 3306

socket          =/home/mysql/mysql/mysql/mysqld.sock

#prompt          ="(\u@\h \\R:\\m:\\s) [\d]> "

default-character-set=utf8

[mysqld_safe]

user            = mysql

nice            = 0

#ledir           =/usr/local/mysql/libexec

[mysqld]

server-id               = 1

port                   = 3306

pid-file                 = /home/mysql/mysql/mysql/mysqld.pid

socket                  = /home/mysql/mysql/mysql/mysqld.sock

basedir                 = /usr/local/mysql

datadir                 = /home/mysql/mysql/mysql/

innodb_data_home_dir    = /home/mysql/mysql/mysql/

innodb_log_group_home_dir       = /home/mysql/mysql/mysql/

tmpdir                  = /home/mysql/mysql/mysql/

log-error               = /home/mysql/mysql/mysql/mysqld.log

slow_query_log          =1

slow_query_log_file     = /home/mysql/mysql/mysql/mysql-slow.log

lower_case_table_names  = 1

log_bin                 = /home/mysql/mysql/mysql/mysql-bin.log

log_slave_updates   =  0

skip-slave-start

skip-name-resolve

lower_case_table_names=1

user                    = mysql

#language                = /usr/local/mysql/share/mysql/english

#table_cache             = 512

long_query_time         = 1

max_connections         = 600

query_cache_type        = 0

#default-character-set      = utf8

character-set-server = utf8

default-storage-engine     = innodb

skip-external-locking

expire_logs_days        = 7

max_binlog_size         = 100M

innodb_buffer_pool_size = 2G

innodb_data_file_path   = ibdata1:1024M:autoextend

innodb_autoextend_increment     = 128

innodb_log_files_in_group       = 2

innodb_log_file_size            = 512M

#innodb_lock_wait_timeout        = 5

innodb_flush_method            = O_DIRECT

innodb_flush_log_at_trx_commit   = 2

innodb_file_per_table   = 1

innodb_file_format         =Barracuda

innodb_file_format_check   =Barracuda

#innodb_adaptive_checkpoint  =estimate

#innodb_expand_import       = 1

innodb_read_io_threads      = 1

innodb_stats_method        = nulls_unequal

innodb_thread_concurrency  = 12

innodb_write_io_threads    = 1

innodb_io_capacity         =800

#read_only                  = on 

[mysqldump]

quick

quote-names

max_allowed_packet      = 16M

#default-character-set       = utf8

[mysql]

#default-character-set = utf8

/mysql/bin/mysqld_safe --defaults-file=/home/mysql/mysql/my-pos.cnf

本文出自 “DavideyLee” 博客，请务必保留此出处http://davideylee.blog.51cto.com/8703117/1532743