Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.25, 10.1.14
-
Ubuntu x86_64
-
10.0.26, 10.0.28, 5.5.55, 10.0.30
Description
Enabling the thread pool leads to about 5% performance loss in MariaDB 10.0 and 10.1, but not in MariaDB 5.5. I tested 5.5.49 vs. 10.0.25 vs. 10.1.14.
The benchmark is sysbench OLTP read-only with 1000 point-selects per transaction. The benchmark machine has 16 cores (32 hyperthreads).
my.cnf:
[mysqld]
|
max_connections = 1300
|
table_open_cache = 2600
|
query_cache_type = 0
|
|
innodb_buffer_pool_size = 512M
|
innodb_buffer_pool_instances = 10
|
innodb_adaptive_hash_index_partitions = 20
|
|
thread_handling=pool-of-threads
|
See attached spread sheet for numbers.
Attachments
Activity
Transition | Time In Source Status | Execution Times |
---|
|
41d 4h 43m | 1 |
|
390d 18h 50m | 1 |
|
1d 17m | 1 |
|
4d 20h 11m | 1 |