mysql5性能比较_MySQL性能比较测试：MySQL5.6GA-vs-MySQL5.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 调整:

，

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网