Bug #56145 5.6.0 - Gains in high thread count, losses in lower threads

• Submitted: 20 Aug 2010 13:34
• Modified: 13 May 2014 12:13
• Reporter: Jonathan Miller
• Status: Can't repeat
• Category: MySQL Server: InnoDB Plugin storage engine
• Severity: S5 (Performance)
• Version: 5.6.*
• OS: Windows
• Assigned to: Assigned Account
• CPU Architecture: Any

[20 Aug 2010 13:34] Jonathan Miller

Description:
ATR Performance testing shows great gains over past version for the higher thread counts, yet we have loss some performance in the lower thread count.

How to repeat:
Repeatable using Sysbench on Windows.

[mysqld]
sql-mode="NO_ENGINE_SUBSTITUTION"
user=root
port=3306
max_connections=500
max_connect_errors=10
table_cache=2048
max_allowed_packet=1048576
binlog_cache_size=1048576
max_heap_table_size=67108864
sort_buffer_size=65536
join_buffer_size=1048576
thread_cache=16
query_cache_size=0
ft_min_word_len=4
transaction_isolation=REPEATABLE-READ
tmp_table_size=64M
loose-skip-locking
server-id=1
innodb_status_file=0
innodb_data_file_path=ibdata1:100M:autoextend
innodb_buffer_pool_size=1300M
innodb_additional_mem_pool_size=20M
innodb_log_file_size=100M
innodb_log_files_in_group=2
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=2
innodb_lock_wait_timeout=300
innodb_locks_unsafe_for_binlog=0
innodb_thread_concurrency=0
# Uncomment for Linux testing
#innodb_flush_method=O_DIRECT

[13 May 2014 12:13] Erlend Dahl

Not repeatable on later 5.6.