MySQL 5.7.17 VS MariaDB 10.1.19 Enterprise性能压测

  1. 云栖社区>
  2. 博客>
  3. 正文

MySQL 5.7.17 VS MariaDB 10.1.19 Enterprise性能压测

技术小甜 2017-11-09 18:55:00 浏览1628
展开阅读全文

为了验证MariaDB官网压测结果,特找了三台低配物理机做压测

https://mariadb.org/maria-10-1-mysql-5-7-commodity-hardware/

wKiom1hsnD6R8GeCAABg0QleQsQ040.gif

1
2
3
192.168.143.244 sysbench
192.168.143.245 MySQL 5.7.17
192.168.143.246 MariaDB 10.1.19 Enterprise


工具sysbench0.5 128并发 10张表100万行

硬件配置R720 64G RAID10(SAS 15000转)


分别压测30分钟

1
2
3
4
5
6
sysbench 
--test=/root/soft/sysbench-0.5/sysbench/tests/db/oltp.lua 
--mysql-table-engine=innodb --oltp-table-size=1000000 --max-requests=0 
--max-time=1800 --num-threads=128 --oltp-tables-count=10 
--report-interval=10 --mysql-host=192.168.143.245 --mysql-port=3306 
--mysql-user=admin --mysql-password=123456  --mysql-db=test run


压测参数-参考官网:

https://mariadb.org/performance-evaluation-of-mariadb-10-1-and-mysql-5-7-4-labs-tplc/

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
######### InnoDB #############
innodb_sort_buffer_size = 32M
innodb_rollback_on_timeout = 1
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_size = 30G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 128M
innodb_log_buffer_size = 32M
innodb_log_files_in_group = 3
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 10
innodb_sync_spin_loops = 40
innodb_max_dirty_pages_pct = 95
innodb_support_xa = 1
innodb_thread_concurrency = 0
innodb_thread_sleep_delay = 500
innodb_concurrency_tickets = 1000
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_read_io_threads = 12
innodb_write_io_threads = 12
innodb_io_capacity = 600
innodb_file_format = Barracuda
innodb_purge_threads = 8
innodb_purge_batch_size = 32
innodb_old_blocks_time = 1000
innodb_change_buffering = all
transaction_isolation = READ-COMMITTED
innodb_stats_on_metadata = 0
performance_schema = 0


192.168.143.245(MySQL 5.7.17,Buffer_Pool_Size为30G)

压测结果

wKioL1hskIHB8fIpAABq9-ZP7GQ765.png

wKiom1hskIGiYmuBAABCiZRIGqU552.png

wKioL1hskILjrZtWAACqiRhl8wI647.png

wKiom1hskIPBzkCnAABngWIxLrw228.png

wKiom1hslyvBRaQjAAA3sKoyu1o384.png

--------------------------------------------------

192.168.143.246(MariaDB 10.1.19 Enterprise,Buffer_Pool_Size为30G,未开启Thread Pool线程池)

压测结果

wKioL1hsl82TV6a_AABiMlbCbgo287.png

wKiom1hsl86AUsdVAABJ2LHLWXs327.png

wKiom1hsl87Qoa8rAACmpyK4oTA324.png

wKioL1hsl8_AXRsHAABp-tcFQ3Q872.png

wKiom1hsl8_C7rLUAAA3nDSPIT4443.png


-------------------------------------------------

总结

在QPS相同的情况下,MariaDB 10.1.19 Enterprise在CPU负载上利用率更低,基本符合MariaDB官网的压测结果。




















本文转自hcymysql51CTO博客,原文链接:http://blog.51cto.com/hcymysql/1888921 ,如需转载请自行联系原作者


网友评论

登录后评论
0/500
评论
技术小甜
+ 关注