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?

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

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28495 Corruption due to attempting to start up multiple servers on the same data

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28662 [ERROR] mysqld got signal 11 after updating from 10.4.8 to 10.4.24

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28697 One Node crashed and did not recover

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28976 InnoDB: Missing FILE_CHECKPOINT

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31568 innodb protection against dual processes accessing data insufficient

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link MySQL Bug #3608 INNODB allows a new process to start when the database is still shutting down.

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            		36d 12h 5m 1
            Marko Mäkelä made transition -
            Confirmed In Progress
            		188d 51m 1
            Marko Mäkelä made transition -
            In Progress In Review
            		18m 3s 1
            Sergei Golubchik made transition -
            In Review Stalled
            		3d 1h 19m 1
            Marko Mäkelä made transition -
            Stalled Closed
            		14h 14m 1

            People

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