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

Increased waits for synch/mutex/aria/PAGECACHE::cache_lock

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.2.21
    • N/A
    • Storage Engine - Aria
    • None
    • AWS RDS db.m5.4xlarge
      16vCPU 64GB RAM

    Description

      About a couple of days ago, a query that was normally working fast started crashing and getting stuck in "Sending data". These eventually pile up and freeze the db.
      The query in question is a select on a more complicated view that contains some joins and a union.
      I have already created a thread on aws forums about the issue that I'm seeing and added more information as well as performance insights.
      https://forums.aws.amazon.com/thread.jspa?messageID=921037#921037

      Attachments

        Activity

          People

            axel Axel Schwenke
            np@danalock.com Nicolae Popa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.