Maison > Article > base de données > MySQL 性能比较测试:MySQL 5.6 GA -vs- MySQL 5.5
MySQL 5.6 GA 发布了,毫无疑问,这是 MySQL 最棒的一个版本。如果你还不清楚 MySQL 5.6 版本一长串的新特性和改进内容,可以从这
MySQL 5.6 GA 发布了,毫无疑问,这是 MySQL 最棒的一个版本。
如果你还不清楚 MySQL 5.6 版本一长串的新特性和改进内容,可以从这里获得了解。
而我这篇文章的主要目的则是性能的测试。
我使用 Sysbench workloads (Read-Only/Read-Write) 来测试。下面是我的测试环境:
硬件配置:
MySQL 配置:
#--------------------------------------------------
max_connections = 4000
key_buffer_size = 200M
low_priority_updates = 1
sort_buffer_size = 2097152
back_log = 1500
query_cache_type = 0
# files
innodb_file_per_table
innodb_log_file_size = 1024M
innodb_log_files_in_group = 3
innodb_open_files = 4000
table_open_cache = 8000
table_open_cache_instances = 16
# buffers
innodb_buffer_pool_size = 32000M
innodb_buffer_pool_instances = 32
innodb_log_buffer_size = 64M
join_buffer_size = 32K
sort_buffer_size = 32K
# tune
innodb_checksums = 0
innodb_doublewrite = 0
innodb_support_xa = 0
innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_max_dirty_pages_pct = 50
innodb_use_native_aio =1
innodb_stats_persistent = 1
innodb_spin_wait_delay = 6 / 96
# perf special
innodb_adaptive_flushing = 1
innodb_flush_neighbors = 0
innodb_read_io_threads = 16
innodb_write_io_threads = 4
innodb_io_capacity = 2000
innodb_purge_threads =1
innodb_adaptive_hash_index = 1 / 0
# Monitoring
innodb_monitor_enable = '%'
performance_schema = ON
performance_schema_instrument = '%=on'
#--------------------------------------------------
MySQL 调整:
,