Skip navigation links

MySQL Forums :: Performance :: my.cnf for MySQL 5.5 on CentOS 5.5 recomandations


Advanced Search

my.cnf for MySQL 5.5 on CentOS 5.5 recomandations
Posted by: Roni Alboim ()
Date: February 01, 2011 09:58AM

I have a dedicated server for MySQL with 12 core 32GB mem 10TB RAID-10 disk space, mainly inserts with few batch jobs once a day and I need to configure it, I came up with the following my.cnf:

[client]
password = [passwd]
port = 3306
socket = /var/lib/mysql/mysql.sock

datadir = /storage/mysql/data


[mysqld]
# innodb_force_recovery = 6
# innodb_rollback_on_timeout

event_scheduler = ON

skip-character-set-client-handshake
collation_server = utf8_unicode_ci
character_set_server = utf8

port = 3306
socket = /var/lib/mysql/mysql.sock
back_log = 50
max_connections = 2000
max_connect_errors = 4294967295
table_open_cache = 2048
max_allowed_packet = 32M
binlog_cache_size = 1M
max_heap_table_size = 64M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
sort_buffer_size = 50M # Roni: 8M
join_buffer_size = 8M
thread_cache_size = 8
thread_concurrency = 24
query_cache_size = 64M
query_cache_limit = 2M
ft_min_word_len = 4
#memlock
default-storage-engine = MYISAM
thread_stack = 192K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 64M
log-bin =mysql-bin
binlog_format =mixed
#log_slave_updates
#log
#log_warnings
slow_query_log
long_query_time = 100

lower_case_table_names = 1

#Time Outs
interactive_timeout =100
wait_timeout =100
connect_timeout =60

#*** MyISAM Specific options

key_buffer_size = 32M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover


#skip-innodb

tmpdir =/storage/mysql/tmpdir

innodb_data_home_dir =/storage/mysql/data
innodb_log_group_home_dir =/storage/mysql

innodb_additional_mem_pool_size = 32M
innodb_buffer_pool_size = 8G
#innodb_data_file_path = ibdata1:10M:autoextend
innodb_data_home_dir = /storage/mysql/data
innodb_write_io_threads = 8
innodb_read_io_threads = 8
#innodb_force_recovery = 1
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2 # Roni: 1
#innodb_fast_shutdown
innodb_log_buffer_size = 20M # Roni: 8M
innodb_log_file_size = 1G # Roni: 256M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_flush_method = O_DIRECT # Roni: O_DSYNC
innodb_lock_wait_timeout = 120
innodb_file_per_table

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

#safe-updates

[myisamchk]
key_buffer_size = 512M
sort_buffer_size = 512M
read_buffer = 64M # Roni: 8M
write_buffer = 64M # Roni: 8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
open-files-limit = 8192

any suggestions?

TX,

Roni

Options: ReplyQuote


Subject Views Written By Posted
my.cnf for MySQL 5.5 on CentOS 5.5 recomandations 11467 Roni Alboim 02/01/2011 09:58AM
Re: my.cnf for MySQL 5.5 on CentOS 5.5 recomandations 2955 Rick James 02/03/2011 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.