Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4.6
-
None
-
Linux Fedora 30 on PPC64
AIX 7.1 on PPC64
Description
Hi,
Test sys_vars.host_cache_size_auto fails on Linux and AIX with the following error:
select @@global.host_cache_size; |
@@global.host_cache_size
|
-632
|
+653
|
Default cache size is defined in file mysqld.cc, line ~4271. Comments and code said cache size is 128 + min(connection, 500) + max(connection-500, 0)/20, capped at 2000. With 1000 connection (defined in mysql-test/suite/sys_vars/t/host_cache_size_auto-master.opt), we reach 653. We obtain the right value according to comment and code. Value wanted by the test is different.
Value wanted by the test was changed one year ago by a merge (https://github.com/MariaDB/server/blame/10.5/mysql-test/suite/sys_vars/r/host_cache_size_auto.result).
Can you confirm the old (653) value is the right one? Can you reproduce in a non-ppc architecture?
Thanks,
Étienne.