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

table_open_cache creates same number of advisory /proc/locks. Is it worth it?

    XMLWordPrintable

    Details

      Description

      MariaDB table_open_cache generates same and excessive number of advisory /proc/locks that causes OTHER programs on machine to waste cpu power ("sys load") when checking for locks. Are those really needed/worth it?
      Executing lsof command while there are 100k locks in /proc/locks (made by mariadb with table_open_cache=100k) takes 2 minutes.
      I see huge decrease in "sys" load after reducing table_open_cache from 100k to 4k on graphs.

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            naox naox
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.