Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
12.0.1
-
None
-
linux kernel is 5.15.0-76-generic(ubuntu~22.04.1)
Description
After commit f11504a, MariaDB performance appears to be degraded when executing the update statement:
UPDATE comments SET post_id=post_id+1 WHERE id>1000; |
We tested it using mysqlslap with the following test statement:
./mysqlslap --concurrency=1 --iterations=1 --create-schema=test --query="$mariaDB_inst" -uroot -S $(pwd)/bin/mysql.sock --number-of-queries=10000
|
The result of the test statement is as follows:
Before f11504a:
Average number of seconds to run all queries: 540.658 seconds
Minimum number of seconds to run all queries: 540.658 seconds
Maximum number of seconds to run all queries: 540.658 seconds
Number of clients running queries: 1
Average number of queries per client: 10000
After f11504a:
Average number of seconds to run all queries: 574.658 seconds
Minimum number of seconds to run all queries: 574.658 seconds
Maximum number of seconds to run all queries: 574.658 seconds
Number of clients running queries: 1
Average number of queries per client: 10000
you can pre-populated data by init.sql and insert.sql
Attachments
Issue Links
- is caused by
-
MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR
-
- Closed
-