XtraDB Thread Priority Flag
Some of the InnoDB worker threads compete for the shared resource accesses with the query threads. Performance experiments show that under high concurrency the worker threads must acquire the shared resources with priority. This blueprint is about implementing a flag that is per-thread and whose value indicates whether the current thread is prioritized or not. Actual uses of the flag will be in follow-up blueprints.
Since the performance experiments on the exact final priority setup are not finished, introduce dynamic, boolean plugin variables for manipulating these flags for selected threads:
- innodb_
- innodb_priority_io;
- innodb_
- innodb_
These variables are intended for performance experimenting and not regular user tuning (so that we are able to adjust the defaults for the regular users). Thus they should be UNIV_PERF_
The easiest and least overhead-
Blueprint information
- Status:
- Complete
- Approver:
- Alexey Kopytov
- Priority:
- High
- Drafter:
- Laurynas Biveinis
- Direction:
- Approved
- Assignee:
- Laurynas Biveinis
- Definition:
- Approved
- Series goal:
- Accepted for 5.6
- Implementation:
- Implemented
- Milestone target:
- 5.6.13-61.0
- Started by
- Laurynas Biveinis
- Completed by
- Laurynas Biveinis
Related branches
Related bugs
Sprints
Whiteboard
Work Items
Dependency tree
* Blueprints in grey have been implemented.