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

map a linux pid (child pid) to a connection id shown in the output of SHOW PROCESSLIST

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.8
    • OTHER
    • None
    • 10.1.6-1, 10.1.6-2, 10.1.8-1, 10.1.8-2

    Description

      We have have a multi-threaded program with multiple connections to the database. While this program is running, we often get a single child process (pid) that just hangs. This particular child process consumes 100% of any given CPU. We are trying to troubleshoot this and trying to determine which child pid maps to the SHOW PROCESSLIST Id.

      With that in mind, we would like to know if there is a way to map a linux child pid that's associated with the linux parent pid (ppid) of the mysqld process to the Id shown in the output of SHOW PROCESSLIST.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              hhiggs Harry Higgs
              Votes:
              4 Vote for this issue
              Watchers:
              9 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.