[MDEV-29608] Default SSL makes mysqlslap much slower, tests fail with timeout Created: 2022-09-22  Updated: 2023-03-29  Resolved: 2023-03-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.10
Fix Version/s: 10.11.3, 10.10.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-27105 --ssl option set as default for maria... Closed

 Description   

Starting from this push in 10.10

Author: Sergei Golubchik
Date:   Mon May 23 12:43:22 2022 +0200
 
    MDEV-27105 --ssl option set as default for mariadb CLI
    
    but without server cert verification

some tests take many times longer, and almost inevitably fail with timeout. E.g. rocksdb.concurrent_alter fails on nearly every build/builder in buildbot, while before the change it was only taking a few seconds.

On my machine the ratio is not as big, but still very visible (it's the command that the test runs inside):

$ time $MYSQL_SLAP  --silent --delimiter=";" --query="select * from a1 where a=1" --concurrency=16 --iterations=1000
 
real	0m10.935s
user	0m9.951s
sys	0m3.147s
 
$ time $MYSQL_SLAP --skip-ssl --silent --delimiter=";" --query="select * from a1 where a=1" --concurrency=16 --iterations=1000
 
real	0m0.841s
user	0m0.457s
sys	0m2.026s

Probably there are other affected tests, the rocksdb is only most visible because it actually fails.

we probably need to change MTR default config to turn off SSL for mysqlslap, but first it needs to be confirmed that such a difference in default client performance is expected.


Generated at Thu Feb 08 10:09:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.