为了验证MariaDB官网压测结果，特找了三台低配物理机做压测
/maria-10-1-mysql-5-7-commodity-hardware/
192.168.143.244sysbench192.168.143.245MySQL5.7.17192.168.143.246MariaDB10.1.19Enterprise
工具sysbench0.5 128并发 10张表100万行
硬件配置R720 64G RAID10(SAS 15000转)
分别压测30分钟
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=testrun
压测参数-参考官网：
/performance-evaluation-of-mariadb-10-1-and-mysql-5-7-4-labs-tplc/
#########InnoDB#############innodb_sort_buffer_size=32Minnodb_rollback_on_timeout=1innodb_data_file_path=ibdata1:10M:autoextendinnodb_buffer_pool_dump_at_shutdown=1innodb_buffer_pool_load_at_startup=1innodb_buffer_pool_size=30Ginnodb_buffer_pool_instances=8innodb_log_file_size=128Minnodb_log_buffer_size=32Minnodb_log_files_in_group=3innodb_flush_log_at_trx_commit=2innodb_lock_wait_timeout=10innodb_sync_spin_loops=40innodb_max_dirty_pages_pct=95innodb_support_xa=1innodb_thread_concurrency=0innodb_thread_sleep_delay=500innodb_concurrency_tickets=1000innodb_flush_method=O_DIRECTinnodb_file_per_table=1innodb_read_io_threads=12innodb_write_io_threads=12innodb_io_capacity=600innodb_file_format=Barracudainnodb_purge_threads=8innodb_purge_batch_size=32innodb_old_blocks_time=1000innodb_change_buffering=alltransaction_isolation=READ-COMMITTEDinnodb_stats_on_metadata=0performance_schema=0
192.168.143.245（MySQL 5.7.17，Buffer_Pool_Size为30G）
压测结果
--------------------------------------------------
192.168.143.246（MariaDB 10.1.19 Enterprise，Buffer_Pool_Size为30G，未开启Thread Pool线程池）
压测结果
-------------------------------------------------
总结
在QPS相同的情况下，MariaDB 10.1.19 Enterprise在CPU负载上利用率更低，基本符合MariaDB官网的压测结果。
