maria:10.11-MDEV-16232

Branch merges

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related charm recipes

78ee4b8... by THIRUNARAYANAN BALATHANDAYUTHAPANI on 2023-01-06

MDEV-16232 Use fewer mini-transactions

- Fail to change the latch operation in row_search_mvcc.

cee15ce... by Oleg Smirnov on 2023-01-02

MDEV-16232: Use fewer mini-transactions

SQL Layer support #3.
Add checks of applicability for UPDATEs and DELETEs.

Rename "operations batch" to "mini transactions" to disambiguate
the term "batch" which is already used.

Temporary disable mini-transactions for SELECTs.

f1f432c... by Sergey Petrunia on 2022-06-08

MDEV-16232: Use fewer mini-transactions

SQL layer support part #2. The main idea is:
employ this optimization only when the query is using just one table.
(the scope is too limited but the goal is to get sysbench to work).

Make UPDATE, DELETE, and SELECT codepaths check that the query has just
one table before the optimization is employed.

Also: in DELETE code, the start_operations_batch/end_operations_batch
were in the "Direct DELETE" branch. I think it's a mistake as InnoDB
doesn't use Direct DELETE optimization.
Removed the calls from there and added them to the regular DELETE codepath.

517ac8e... by THIRUNARAYANAN BALATHANDAYUTHAPANI on 2023-01-05

MDEV-16232 Use fewer mini-transactions

- For update operation, InnoDB uses separate mtr for the following:
1) searching the key in primary key leaf page, stores the position
2) exclusive lock the primary key leaf page
3) Allocate the undo log page, write the undo log record
4) Modify the PRIMARY KEY index change

InnoDB should use the single mtr for the all above conditions.

70be599... by Otto Kekäläinen on 2022-11-27

Deb: Misc fixes for 10.11 series

- Prefer Breaks+Replaces over Conflicts+Replaces in debian/control.

- Clean away conflict/break/replace with self as it either has no
  effect or harmfully prevents upgrades to self (packages from this
  source version).

- Remove references to mariadb-server-10.11 as the package names no
  longer have versions and thus such references are unnecessary cruft.

- Apply 'wrap-and-sort -av' and minor typo fixing.

- Extend Salsa-CI to test for upgrades from 10.9 and 10.10 to 10.11.

- Add minimal required new Lintian overrides so Salsa-CI would not
  fail on Lintian.

cfaf47a... by Daniel Black on 2023-01-03

acl - is_public - avoid embedded warning

Using clang generates the unused-function warning on embedded like:

FAILED: libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_acl.cc.o
/usr/lib64/ccache/clang++ .... libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_acl.cc.o -MF libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_acl.cc.o.d -o libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_acl.cc.o -c /home/dan/repos/mariadb-server-10.11/sql/sql_acl.cc

sql_acl.cc:113:20: error: unused function 'is_public' [-Werror,-Wunused-function]
static inline bool is_public(const LEX_USER *l) { return is_public(&l->user); }

22491e6... by Oleksandr "Sanja" Byelkin on 2022-12-07

MDEV-30154: Assertion `strcasecmp(rolename, public_name.str) || acl_public == role' failed in acl_update_role on GRANT ... TO PUBLIC

Reset of acl_public was made too early (before saving it to restore in case
of error).

a5be6c9... by Daniel Black on 2022-10-26

MDEV-29889 mariadb-dump --tab --header is slow

--header applied an ORDER BY to ensure that the header
row was the first row in the output given UNION ALL
doesn't in the standard enforce the order.

We change that now only add the ORDER BY if --order-by-primary
is used.

An assumption that if UNION ALL change to a different behaviour
the resulting mysqldump-header test may also change.

c194db3... by Marko Mäkelä on 2022-12-16

Merge 10.10 into 10.11

3217ecd... by Marko Mäkelä on 2022-12-16

Merge 10.9 into 10.10