[MDEV-9871] benchmark the 10.2 fast-connect tree Created: 2016-04-05  Updated: 2017-06-13  Due: 2016-04-22  Resolved: 2017-06-13

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: 10.2.6

Type: Task Priority: Minor
Reporter: Axel Schwenke Assignee: Axel Schwenke
Resolution: Fixed Votes: 0
Labels: None

Attachments: File MDEV-9871.ods    

 Description   

Source tree is bb-fast-connect (based on 10.2).
Compare performance with 10.2-current.

Montys results follow


All tests with run with storage engine MyISAM (to get predictable results):

./sysbench/sysbench --test=./sysbench/tests/db/ro_connect.lua --mysql-db=test --oltp-tables-count=16 --oltp-table-size=1000000 --mysql-socket=/tmp/mysql.sock --num-threads=32 --max-requests=0 --max-time=30 --report-interval=2 prepare
 
./sysbench/sysbench --test=./sysbench/tests/db/ro_connect.lua --mysql-db=test --oltp-tables-count=16 --oltp-table-size=1000000 --mysql-socket=/tmp/mysql-dbug.sock --num-threads=32 --max-requests=0 --max-time=300 --report-interval=100 --mysql-user=monty
 
10.1 Thread_cache_size=0   28955 reads/seconds
10.1 Thread_cache_size=64  47441 reads/seconds
10.2-move-thd Thread_cache_size=0  26087
10.2-move-thd Thread_cache_size=64 50550
10.2-use-thd thread-cache-size=0   26180
10.2-use-thd thread-cache-size=64  53704
10.2-use-thd thread-cache-size=64 malloc  53618
 
5.7 thread-cache-size=0            21729
5.7 thread-cache-size=0 perf=0     22213.53
5.7 thread-cache-size=64 perf=0    39712.26



 Comments   
Comment by Axel Schwenke [ 2017-06-13 ]

This task was delayed and 10.2 fast-connect has long since been merged with the 10.2 main tree. Hence I did not test fast-connect vs. 10.2 (before merge) but rather test different MariaDB server versions.

In 10.2 the connect performance is about 3x as fast as in earlier versions (tested: 5.5 to 10.1). That however comes partly from the fact that the thread cache is by default enabled in 10.2 but was disable in earlier versions. If the thread cache is set to 64, then 10.2 is still 2x faster than previous versions.

For details check the attached spread sheet.

Generated at Thu Feb 08 07:37:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.