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

P_S.THREADS is still not showing all server threads in 11.4.5

Details

    Description

      P_S.THREADS is still not showing all server threads in 11.4.5

      SQL> select @@version;
      +--------------------------+
      | @@version                |
      +--------------------------+
      | 11.4.5-MariaDB-deb12-log |
      +--------------------------+
       
      SQL> select name, type, THREAD_OS_ID from performance_schema.threads; 
      +------------------------------------+------------+--------------+
      | name                               | type       | THREAD_OS_ID |
      +------------------------------------+------------+--------------+
      | thread/sql/main                    | BACKGROUND |       150006 |
      | thread/mysys/statement_timer       | BACKGROUND |       150007 |
      | thread/sql/wsrep_rollbacker_thread | FOREGROUND |       150011 |
      | thread/sql/wsrep_applier_thread    | FOREGROUND |       150012 |
      | thread/aria/checkpoint_background  | BACKGROUND |       150166 |
      | thread/innodb/page_cleaner_thread  | BACKGROUND |       150169 |
      | thread/sql/manager                 | BACKGROUND |       150175 |
      | thread/sql/binlog_background       | BACKGROUND |       150176 |
      | thread/sql/signal_handler          | BACKGROUND |       150177 |
      | thread/sql/one_connection          | FOREGROUND |       150190 |
      | thread/sql/one_connection          | FOREGROUND |       150205 |
      | thread/innodb/thread_pool_thread   | BACKGROUND |       150618 |
      | thread/sql/one_connection          | FOREGROUND |       150890 |
      +------------------------------------+------------+--------------+
       
      # ps -eLf | grep mariadbd
      mysql     150006       1  150006  0   18 09:57 ?        00:01:41 /usr/sbin/mariadbd
      mysql     150006       1  150007  0   18 09:57 ?        00:00:01 /usr/sbin/mariadbd
      mysql     150006       1  150008  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150009  0   18 09:57 ?        00:00:11 /usr/sbin/mariadbd
      mysql     150006       1  150010  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150011  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150012  0   18 09:57 ?        00:00:02 /usr/sbin/mariadbd
      mysql     150006       1  150166  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150167  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150168  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150169  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150175  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150176  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150177  0   18 09:57 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150190  0   18 09:57 ?        00:00:43 /usr/sbin/mariadbd
      mysql     150006       1  150205  0   18 09:57 ?        00:00:34 /usr/sbin/mariadbd
      mysql     150006       1  150618  0   18 12:42 ?        00:00:00 /usr/sbin/mariadbd
      mysql     150006       1  150890  0   18 13:55 ?        00:00:00 /usr/sbin/mariadbd
      

      Attachments

        Issue Links

          Activity

            No workflow transitions have been executed yet.

            People

              sysprg Julius Goryavsky
              oli Oli Sennhauser
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.