[MDEV-20112] Test sys_vars.host_cache_size_auto fails Created: 2019-07-22 Updated: 2022-04-05 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Tests |
| Affects Version/s: | 10.4.6 |
| Fix Version/s: | 10.4 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Etienne Guesnet | Assignee: | Oleksandr Byelkin |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Linux Fedora 30 on PPC64 |
||
| Description |
|
Hi,
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, |
| Comments |
| Comment by Etienne Guesnet [ 2019-07-22 ] |
|
New information: test fails only on root. It works with a "mysql" (non root) user. sys_vars.table_open_cache_basic |
| Comment by Oleksandr Byelkin [ 2019-10-11 ] |
|
test should be fixed (or removed) before testing it should be set to defeult, otherwise test depend on host settings |
| Comment by Etienne Guesnet [ 2019-10-30 ] |
|
We can add "--source include/not_as_root.inc" in the beginning of the tests file. So, tests will be skipped if one tries to execute it as root. Do you want I create an associated pull request? |