ClickHouse 线程占用排查及查杀

ps H  -o 'tid comm' $(pidof -s clickhouse-server) | awk '{print $2}'  | sort | uniq -c | sort -rn
    354 QueryPipelineEx
     16 BgDistSchPool
     15 TCPHandler
     10 clickhouse-serv
      6 BgSchPool
      5 HTTPHandler
      3 SystemLogFlush
      2 ExterLdrReload
      2 ConfigReloader
      1 ZooKeeperSend
      1 ZooKeeperRecv
      1 TraceCollector
      1 SessionCleaner
      1 DDLWorkerClnr
      1 DDLWorker
      1 COMMAND
      1 BgSchPool/D
      1 BgDistSchPool/D
      1 AsyncMetrics
      
      
for i in $(ls -1 /proc/$(pidof clickhouse-server)/task/); do  echo $i ; done