Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Idea is to completely avoid the pattern where thread holds dict_sys.mutex and does
i/o on redo log or any other case. It also allocates more heap storage
which are not necessary in most cases. Plan is to remove the parser
from innodb system table usage. This should be follow up task of MDEV-28730.
Currently, InnoDB dictionary table SYS_TABLES & SYS_FOREIGN has secondary
index.
|
|
/* The field numbers in the SYS_TABLE_IDS index */
|
enum dict_fld_sys_table_ids_enum {
|
DICT_FLD__SYS_TABLE_IDS__ID = 0,
|
DICT_FLD__SYS_TABLE_IDS__NAME = 1,
|
DICT_NUM_FIELDS__SYS_TABLE_IDS = 2
|
};
|
|
|
/* The field numbers in the SYS_FOREIGN_FOR_NAME secondary index */
|
enum dict_fld_sys_foreign_for_name_enum {
|
DICT_FLD__SYS_FOREIGN_FOR_NAME__NAME = 0,
|
DICT_FLD__SYS_FOREIGN_FOR_NAME__ID = 1,
|
DICT_NUM_FIELDS__SYS_FOREIGN_FOR_NAME = 2
|
};
|
Attachments
Issue Links
- is blocked by
-
-
- In Progress
-