Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4.5
-
None
-
Debian 12, n.a.
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
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Assignee | Julius Goryavsky [ sysprg ] |
| 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 ``` |
P_S.THREADS is still not showing all server threads in 11.4.5
{noformat} 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 {noformat} |