Download MariaDB10.1.22 Spider3.3 Tencent patch sub-library and sub-table

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.