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
|
- relates to
-
MDEV-33978
P_S.THREADS is not showing all server threads
-
-
Closed
{"report":{"fcp":3724.9000000953674,"ttfb":1559.9000000953674,"pageVisibility":"visible","entityId":133037,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"df966bd1-37a3-4e8e-9bb8-03295754967c","navigationType":0,"readyForUser":3821.5,"redirectCount":0,"resourceLoadedEnd":4818.5,"resourceLoadedStart":1568.2999999523163,"resourceTiming":[{"duration":1617.8000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":1568.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1568.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3186.100000143051,"responseStart":0,"secureConnectionStart":0},{"duration":1618.6999998092651,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1568.6000001430511,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1568.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3187.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":1672.6000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":1568.7999999523163,"connectEnd":1568.7999999523163,"connectStart":1568.7999999523163,"domainLookupEnd":1568.7999999523163,"domainLookupStart":1568.7999999523163,"fetchStart":1568.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1568.7999999523163,"responseEnd":3241.4000000953674,"responseStart":3241.4000000953674,"secureConnectionStart":1568.7999999523163},{"duration":1765.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1569.2999999523163,"connectEnd":1569.2999999523163,"connectStart":1569.2999999523163,"domainLookupEnd":1569.2999999523163,"domainLookupStart":1569.2999999523163,"fetchStart":1569.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1569.2999999523163,"responseEnd":3334.7999999523163,"responseStart":3334.7999999523163,"secureConnectionStart":1569.2999999523163},{"duration":1769.1000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":1569.5,"connectEnd":1569.5,"connectStart":1569.5,"domainLookupEnd":1569.5,"domainLookupStart":1569.5,"fetchStart":1569.5,"redirectEnd":0,"redirectStart":0,"requestStart":1569.5,"responseEnd":3338.600000143051,"responseStart":3338.600000143051,"secureConnectionStart":1569.5},{"duration":1769.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":1569.6000001430511,"connectEnd":1569.6000001430511,"connectStart":1569.6000001430511,"domainLookupEnd":1569.6000001430511,"domainLookupStart":1569.6000001430511,"fetchStart":1569.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":1569.6000001430511,"responseEnd":3339.100000143051,"responseStart":3339.100000143051,"secureConnectionStart":1569.6000001430511},{"duration":1769.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":1569.7999999523163,"connectEnd":1569.7999999523163,"connectStart":1569.7999999523163,"domainLookupEnd":1569.7999999523163,"domainLookupStart":1569.7999999523163,"fetchStart":1569.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1569.7999999523163,"responseEnd":3339.5,"responseStart":3339.5,"secureConnectionStart":1569.7999999523163},{"duration":1815.6000001430511,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":1570,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1570,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3385.600000143051,"responseStart":0,"secureConnectionStart":0},{"duration":1769.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1570.2000000476837,"connectEnd":1570.2000000476837,"connectStart":1570.2000000476837,"domainLookupEnd":1570.2000000476837,"domainLookupStart":1570.2000000476837,"fetchStart":1570.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1570.2000000476837,"responseEnd":3340,"responseStart":3340,"secureConnectionStart":1570.2000000476837},{"duration":1815.4000000953674,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":1570.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1570.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3385.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":1770,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":1570.5,"connectEnd":1570.5,"connectStart":1570.5,"domainLookupEnd":1570.5,"domainLookupStart":1570.5,"fetchStart":1570.5,"redirectEnd":0,"redirectStart":0,"requestStart":1570.5,"responseEnd":3340.5,"responseStart":3340.5,"secureConnectionStart":1570.5},{"duration":3119.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":1577.2000000476837,"connectEnd":1577.2000000476837,"connectStart":1577.2000000476837,"domainLookupEnd":1577.2000000476837,"domainLookupStart":1577.2000000476837,"fetchStart":1577.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1577.2000000476837,"responseEnd":4696.299999952316,"responseStart":4696.299999952316,"secureConnectionStart":1577.2000000476837},{"duration":3240.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":1578.4000000953674,"connectEnd":1578.4000000953674,"connectStart":1578.4000000953674,"domainLookupEnd":1578.4000000953674,"domainLookupStart":1578.4000000953674,"fetchStart":1578.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1578.4000000953674,"responseEnd":4818.5,"responseStart":4818.5,"secureConnectionStart":1578.4000000953674},{"duration":1298.0999999046326,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":3398.600000143051,"connectEnd":3398.600000143051,"connectStart":3398.600000143051,"domainLookupEnd":3398.600000143051,"domainLookupStart":3398.600000143051,"fetchStart":3398.600000143051,"redirectEnd":0,"redirectStart":0,"requestStart":3398.600000143051,"responseEnd":4696.700000047684,"responseStart":4696.700000047684,"secureConnectionStart":3398.600000143051},{"duration":1129.1999998092651,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":3712.100000143051,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":3712.100000143051,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":4841.299999952316,"responseStart":0,"secureConnectionStart":0}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":1399,"responseStart":1560,"responseEnd":1579,"domLoading":1564,"domInteractive":4842,"domContentLoadedEventStart":4842,"domContentLoadedEventEnd":4936,"domComplete":6769,"loadEventStart":6769,"loadEventEnd":6771,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":4821.900000095367},{"name":"bigPipe.sidebar-id.end","time":4822.700000047684},{"name":"bigPipe.activity-panel-pipe-id.start","time":4822.900000095367},{"name":"bigPipe.activity-panel-pipe-id.end","time":4825.200000047684},{"name":"activityTabFullyLoaded","time":4943}],"measures":[],"correlationId":"a3c513668dcea","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
