Bug #75386 make innodb_ft_total_cache_size a dynamic variable

• Submitted: 1 Jan 2015 15:04
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: 5.7.6
• OS: Any
• CPU Architecture: Any
• Tags: innodb_ft_cache_size, innodb_ft_total_cache_size

[1 Jan 2015 15:04] Shane Bester

Description:
Since innodb_buffer_pool_size is now dynamic, it would be nice to make innodb_ft_total_cache_size dynamic also.

mysql> set global innodb_buffer_pool_size=1024*1024*100;
Query OK, 0 rows affected (0.00 sec)

mysql> set global innodb_ft_total_cache_size=1024*1024*1024;
ERROR 1238 (HY000): Variable 'innodb_ft_total_cache_size' is a read only variable
mysql> set global innodb_ft_cache_size=1024*1024;
ERROR 1238 (HY000): Variable 'innodb_ft_cache_size' is a read only variable

How to repeat:
set global innodb_ft_total_cache_size=1024*1024*1024;
set global innodb_ft_cache_size=1024*1024;