Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.2, 10.3.0
Description
InnoDB Should skip mvcc and transaction locking for temporary tables in 10.2+. Currently row_search_mvcc() process temporary tables with locking. Temporary tables is private to
the connection. There can be one active transaction in temporary table. So it is not necessary
to use mvcc and transaction locking for temporary tables.
Attachments
Issue Links
- relates to
-
MDEV-16467 MariaDB crashes because of "long semaphore wait"after migrating from 10.1 to 10.3
-
- Closed
-
-
MDEV-16713 Hangs server with repeating log entry
-
- Closed
-
Similarly, InnoDB should skip transactional locking for the change buffer tree. The attachment uniqstack.txt in
MDEV-16467shows that lock_update_delete() is being called via btr_cur_optimistic_delete_func() by ibuf_delete_rec(). There should be no transactions operating on the change buffer tree, hence the locking there is completely unnecessary.I would also disable the use of the adaptive hash index on temporary tables and the change buffer tree if they are not already disabled.