[MDEV-26865] fts_optimize_thread cannot keep up with workload Created: 2021-10-20  Updated: 2022-02-17  Resolved: 2021-10-21

Status: Closed
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
Fix Version/s: 10.2.41, 10.3.32, 10.4.22, 10.5.13, 10.6.5, 10.7.1

Type: Bug Priority: Blocker
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: upstream

Issue Links:
Blocks
blocks MDEV-26867 Merge new release of InnoDB 5.7.36 to... Closed

 Description   

As demonstrated by a following MySQL 5.7 test case with debug instrumentation, fts_optimize_thread is not always keeping up with workload, causing large memory usage.
Bug #32831765 SERVER HITS OOM CONDITION WHEN LOADING TWO INNODB TABLES WITH FTS INDEXES


Generated at Thu Feb 08 09:48:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.