uery-log-file = /opt/mysql/data/mysql-slow.log
log_error = /opt/mysql/data/mysql.err
max_connections = 2000
back_log = 50
skip-external-locking
skip-name-resolve
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 2000
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 16M
thread_concurrency = 8
innodb_data_home_dir = /opt/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/mysql/data
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
#safe-updates
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
"/etc/my.cnf" [New] 62L, 1531C written
[root@mysql support-files]# more /etc/my.cnf
[client]
#password = your_password
port = 3306
socket = /opt/data/mysql.sock
[mysqld]
port = 3306
server-id = 24
datadir = /opt/mysql/data
socket = /opt/mysql/data/mysql.sock
pid-file = /opt/mysql/data/mysql.pid
character-set-server = utf8
default_storage_engine = InnoDB
log-bin = /opt/mysql/data/mysql-bin
binlog_format = row
sync-binlog = 1
slow-query-log = on
slow-query-log-file = /opt/mysql/data/mysql-slow.log
log_error = /opt/mysql/data/mysql.err
max_connections = 2000
back_log = 50
skip-external-locking
skip-name-resolve
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 2000
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 16M
thread_concurrency = 8
innodb_data_home_dir = /opt/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/mysql/data
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
#safe-updates
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
# service mysql start
Starting MySQL....[ OK ]
|