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

lot of active connection cause mysql slow ?

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.21
    • N/A
    • Locking
    • CentOS 6.3 , MariaDB server 10.0.21

    Description

      hi, All
      usually , our mysql server run status:
      thread_connected about 1000, thread_running <10
      recently , At 11:34 of every Saturday , when concurrent connection increased
      thread_connected about 3000, thread_running = 1000
      mysql server slow down, Almost stop read and write, continuous about 1 minutes.
      After thread_running < 10, mysql read and write resume normal.

      At problem time point, show engine innodb status show:
      --Thread 139904453748480 has waited at btr0cur.cc line 586 for 0.0000 seconds the semaphore:
      S-lock on RW-latch at 0x7f3ddae57a10 '&new_index->lock'
      a writer (thread id 139906901120768) has reserved it in mode exclusive
      number of readers 0, waiters flag 1, lock_word: 0
      Last time read locked in file btr0cur.cc line 586
      Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.21/storage/xtradb/btr/btr0cur.cc line 577

      pt-stalk capture files in Attachmens:mysql querstion.zip , please help analyze ,thanks.

      Attachments

        Activity

          People

            Unassigned Unassigned
            sysdljr sysdljr
            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.