Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
Description
Description:
|
------------
|
These path introduces several improvement for InnoDB read-only
|
workload:
|
|
1. Remove trx_sys_t::ro_trx_list, all transaction will start with
|
read only mode, and change to rw mode while encountering DML
|
statement. For more details, refer to mysql worklog WL#6047.
|
|
2. Read view object is cached for read-only statement if no rw
|
statement happens during two read only statements of the same
|
session.
|
|
3. Ignore acquiring lock_sys mutex contention while commiting
|
read only transaction.
|
https://github.com/alibaba/AliSQL/commit/9baeab74a3bea61abd8b7356b47315f53b92f8e9
plinux, I believe this is backport from InnoDB 5.7. At least we have most of these changes in 10.2 and the rest are not applicable as is. Could you check if there're still anything to merge here?