Re: Severe performance problem with mysql 5.5.19
Posted by: Gautam Prashant
Date: June 06, 2013 12:03AM

Hi John,

Here are the CNFs you asked.

Mysql 5.1:
===========

[mysqld]
basedir = /PATH_TO_HOME
datadir = /PATH_TO_DATADIR
binlog-format = Mixed
default-character-set = utf8
default-collation = utf8_general_ci
default-storage-engine = InnoDB
key_buffer = 384M
max_allowed_packet = 60M
max_connections = 500
port = 9606
query_cache_size = 0
read_buffer_size = 2M
read_rnd_buffer_size = 8M
server-id = 1
skip-locking
socket = /tmp/mysql.sock
sort_buffer_size = 2M
table_cache = 512
thread_cache_size = 20
thread_concurrency = 8
lower_case-table_names = 1
slave_compressed_protocol = 1
skip-name-resolve
join_buffer_size = 2M
tmp_table_size = 3G
max_heap_table_size = 3G
wait_timeout = 600
interactive_timeout = 600
innodb_thread_concurrency = 4
max_connect_errors = 1000000
innodb_additional_mem_pool_size = 200M
innodb_autoextend_increment = 10
innodb_autoinc_lock_mode = 2
innodb_buffer_pool_size = 8G
innodb_data_home_dir = /PATH_TO_HOME
innodb_data_file_path = innodb1:10G;innodb2:10G;innodb3:5G;innodb4:5G:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 60
innodb_log_buffer_size = 2M
innodb_log_file_size = 200M
innodb_log_files_in_group = 2
innodb_log_group_home_dir = /PATH_TO_LOG
innodb_support_xa = 0
innodb_table_locks = OFF
transaction-isolation = READ-COMMITTED

Mysql 5.5 ( I have only added the variables which are different)
=========

innodb_thread_concurrency = 16 ( even tried 0 but didn't worked)
innodb_write_io_threads = 8
innodb_read_io_threads = 8

Options: ReplyQuote




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.