全局processlist视图

简介

greatdb_global_processlists是一个greatdb引擎注册的information_schema表，该表显示集群中所有活跃的SQLNODE的show processlist信息。该功能增加时的版本为5.0.8.

详细介绍

表信息

使用方式

• 查询

  select * from information_schema.greatdb_global_processlists;
  

• 示例

  GreatDB Cluster> select * from information_schema.greatdb_global_processlists \G;
  *************************** 1. row ***************************
         sqlnode: local
  Processlist_ID: 5
            User: event_scheduler
            Host: localhost
              Db: NULL
         Command: Daemon
            Time: 369
           State: Waiting on empty queue
            Info: NULL
         Time_ms: 368593
       Rows_sent: 0
   Rows_examined: 0
  *************************** 2. row ***************************
         sqlnode: local
  Processlist_ID: 8
            User: root
            Host: localhost:42762
              Db: test
         Command: Query
            Time: 0
           State: executing
            Info: select * from information_schema.greatdb_global_processlists
         Time_ms: 3
       Rows_sent: 0
   Rows_examined: 0
  *************************** 3. row ***************************
         sqlnode: local
  Processlist_ID: 11
            User: system user
            Host: 
              Db: NULL
         Command: Connect
            Time: 20
           State: waiting for handler commit
            Info: Group replication applier module
         Time_ms: 20038
       Rows_sent: 0
   Rows_examined: 0
  *************************** 4. row ***************************
         sqlnode: local
  Processlist_ID: 14
            User: system user
            Host: 
              Db: NULL
         Command: Query
            Time: 20
           State: Slave has read all relay log; waiting for more updates
            Info: NULL
         Time_ms: 9430
       Rows_sent: 0
   Rows_examined: 0
  *************************** 5. row ***************************
         sqlnode: local
  Processlist_ID: 47
            User: root
            Host: localhost:42766
              Db: NULL
         Command: Query
            Time: 0
           State: init
            Info: show processlist
         Time_ms: 0
       Rows_sent: 0
   Rows_examined: 0
  *************************** 6. row ***************************
         sqlnode: 172.16.70.226:3308
  Processlist_ID: 5
            User: event_scheduler
            Host: localhost
              Db: NULL
         Command: Daemon
            Time: 114
           State: Waiting on empty queue
            Info: NULL
         Time_ms: 114390
       Rows_sent: 0
   Rows_examined: 0
  *************************** 7. row ***************************
         sqlnode: 172.16.70.226:3308
  Processlist_ID: 12
            User: system user
            Host: 
              Db: NULL
         Command: Connect
            Time: 12
           State: waiting for handler commit
            Info: Group replication applier module
         Time_ms: 11739
       Rows_sent: 0
   Rows_examined: 0
  *************************** 8. row ***************************
         sqlnode: 172.16.70.226:3308
  Processlist_ID: 15
            User: system user
            Host: 
              Db: NULL
         Command: Query
            Time: 7
           State: Slave has read all relay log; waiting for more updates
            Info: NULL
         Time_ms: 7058
       Rows_sent: 0
   Rows_examined: 0
  *************************** 9. row ***************************
         sqlnode: 172.16.70.226:3308
  Processlist_ID: 30
            User: root
            Host: localhost:59098
              Db: NULL
         Command: Query
            Time: 0
           State: init
            Info: show processlist
         Time_ms: 0
       Rows_sent: 0
   Rows_examined: 0
  9 rows in set (0.00 sec)
  

• 安装升级

  在升级后，先在所有sqlnode节点上检查是否已经安装了information_schema.greatdb_global_processlists，如果没有则执行如下命令安装：

  INSTALL PLUGIN GREATDB_GLOBAL_PROCESSLISTS SONAME 'ha_greatdb.so';