[MDEV-28730] Remove internal parser usage from InnoDB fts Created: 2022-06-02  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Full-text Search, Storage Engine - InnoDB
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File mdev-28730.patch    
Issue Links:
Blocks
blocks MDEV-11633 Make the InnoDB system tablespace opt... Open

 Description   

InnoDB fulltext index internally uses the parser to fetch, write the string into
the auxilary table, common tables, deleted, deleted cache table

Make the auxilary tables as a part of fts_index_cache_t and doesn't allow the
auxilary table to evicted. Store the common tables as a part of
fts_cache_t. This could avoid taking dict_sys.mutex whenever fts uses
internal parser.

 Comments   
Comment by Marko Mäkelä [ 2022-06-02 ]

I think that this may be infeasible to fix in versions older than 10.6, where the InnoDB dictionary cache handling was simplified by MDEV-24258 and other work. We might also decide that this is too risky to fix in any GA release.

Comment by Thirunarayanan Balathandayuthapani [ 2022-06-06 ]

Attaching the parser removal prototype patch in this MDEV page. mdev-28730.patch

Generated at Thu Feb 08 10:03:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.