Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
-
None
Description
Sync operation locks fts cache, reads one row from cache, releases fts cache. By doing frequent unlock, Incoming DML commit can increase the cache
memory by adding doc ids to cache. This leads to longer sync operation and memory growth.
To address this issue, InnoDB can have 2 cache. When InnoDB does sync operation, it can use already filled one cache and incoming DML
thread can use other cache for adding the doc ids. Here sync operation doesn't have to release the cache lock and it can be done atomically.
Note:
InnoDB should handle 2 cache while doing query read.
Attachments
Issue Links
- relates to
-
MDEV-30996 insert.. select in presence of full text index freezes all other commits at commit time
- Closed