Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
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
|