Shulou(Shulou.com)06/01 Report--

Since Tencent Tspider is not open source, I got the Spider3.3 source code of the original author Kentoku Shiba (integrated with Tencent patch for enhanced performance), and compiled it into the GA version of MariaDB 10.1.22, the binary download address.

Http://www.liyanlan.com/download/mariadb/spider/mariadb-10.1.22-spider-3.3.11-linux-x86_64.tgz

Note: the new version has 110 parameters, 9 more than the previous public beta version of 3.2.37RC.

Tuning parameters:

Spider

Spider_multi_split_read = 1

Spider_low_mem_read = 0

Spider_conn_recycle_mode = 1

Spider_bgs_mode = 1

Spider_bka_mode = 2

Spider_quick_mode = 3

Spider_casual_read = 1

Optimizer_switch = 'engine_condition_pushdown=on,mrr=on,mrr_sort_keys=on'

Spider_block_size = 4294967295

Spider_remote_trx_isolation = 1

Spider_remote_autocommit = 1

Spider_remote_default_database = ON

Spider_use_pushdown_udf = 1

Spider_semi_trx = 1

Spider_semi_trx_isolation = 1

Sysbench pressure test

Sysbench--test=/root/sysbench-0.5/sysbench/tests/db/oltp.lua-report-interval=1-- oltp-read-only=on-- oltp_tables_count=1-- oltp-table-size=1000000-- max-requests=0-- max-time=10-- num-threads=64-- mysql-host=192.168.143.206-- mysql-port=3303-- mysql-user=admin-- mysql-password=123456-- mysql-db=test-- mysql-engine-trx=yes run

Directly connected DB

Single spider (vertical split of the table)-1 MySQL at the back end

Thanks to netizen Luo Feng for providing space for download.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.