Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31398

table_open_cache values greater than 200 ignored

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • 10.6.13
    • N/A
    • Configuration
    • Almalinux 8, CPanel.

    Description

      In /etc/my.cnf, table_open_cache is set to 1024. However, `show variables like 'table_open_cache';` shows 200. If a value LESS than 200 is set in my.cnf, it takes that value, but anything more than 200 and it's capped at 200.

      We can dynamically set it to a higher value using `set global table_open_cache = 1024;`, and that is reflected in the variable, but we can't seem to set a higher value from my.cnf and have it apply after restarting the service.

      `ulimit -n` returns 1024. `open_files_limit` is 40000. We've also checked that there are no other configuration files overriding the value (and besides that wouldn't explain why we can set it to values < 200). Also checked the error log, but didn't see any startup errors there.

      This is happening on three separate new Almalinux 8 servers we've provisioned, but did not occur on our old servers, which were on MariaDB 10.6.12, on CentOS 7.

      Attachments

        Activity

          People

            Unassigned Unassigned
            nstretch Nathan Stretch
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.