MySQL Forums
Forum List  »  Performance

Re: Queriey hangs on "Sending data" state on high traffic
Posted by: Anil Kumar
Date: June 22, 2012 11:14PM

Thanks Aftab,

Our existing my.cnf is as below. Can you please alter the values of parameters as per high traffice website.
We are splitting writes on single master and reads on both slaves and also working on slow queries but it's not a one day job. So would like to request pls suggest config parameters for MySQL 5.5 as I am going to upgrade 5.0 to 5.5.

Waiting for updated config file.
-----------------------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
#bind-address=10.20.117.3

old_passwords=1
tmpdir=/mnt/vol2/mysqltmp/

#tmpdir=/mnt/vol2/mysqltmp/

thread_concurrency = 8

max_allowed_packet=512M
ft_min_word_len=2

long_query_time=1

max_connections = 1500
max_user_connections = 1500
key_buffer = 128M
myisam_sort_buffer_size = 16M
join_buffer_size = 8M
read_buffer_size = 8M
sort_buffer_size = 32M
table_cache = 512
thread_cache_size = 512
interactive_timeout = 25
wait_timeout = 120
connect_timeout = 60
max_connect_errors = 1000
query_cache_limit = 1M
query_cache_size = 512M
query_cache_type = 1
tmp_table_size = 512M
# Following added by MC on 1/15/2012
log-queries-not-using-indexes
log_slow_queries = /mnt/vol2/mysql_log/mysqld_slow-queries.log

innodb_additional_mem_pool_size = 32M
innodb_buffer_pool_size = 8G
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 64M
innodb_log_file_size = 1024M
innodb_lock_wait_timeout = 300

#replication
log_bin
server_id = 1

binlog_do_db = DB Name
binlog_ignore_db = DB Name
binlog_ignore_db = DB Name

[mysqld_safe]
#log-error=/var/log/mysqld.log
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-----------------------------------------------------

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Queriey hangs on "Sending data" state on high traffic
1382
June 22, 2012 11:14PM


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.