[MDEV-27913] innodb_ft_cache_size max possible value (80000000) is too small for practical purposes Created: 2022-02-22  Updated: 2022-06-28  Resolved: 2022-02-24

Status: Closed
Project: MariaDB Server
Component/s: Full-text Search, Storage Engine - InnoDB
Affects Version/s: 10.3
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8

Type: Bug Priority: Critical
Reporter: Valerii Kravchuk Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
Relates
relates to MDEV-25581 MS FTS Bug 103523 also applicable to ... Closed

 Description   

It seems innodb_ft_cache_size is NOT dynamic (see upstream https://bugs.mysql.com/bug.php?id=75386) and accepts values only up to 80000000:

2022-02-22 14:42:29 0 [Warning] option 'innodb-ft-cache-size': unsigned value 2000000000 adjusted to 80000000

This is too small and causes problem like MDEV-25581 that can not be workarounded as a result.

 Comments   
Comment by Thirunarayanan Balathandayuthapani [ 2022-02-23 ]

Patch is in bb-10.3-MDEV-27913

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