Mysql Redis PostgreSQL数据库查看客户端连接

Redis数据库查看连接的客户端

[root@VM_8_24_centos ~]# redis-cli -h 10.0.4.6 -a yourpassword
10.0.4.6:6379> client list
addr=100.120.205.19:1024 fd=9 cmd=client age=3 idle=0 proxy=33c6e51a9cc4771fb5836880f86a860f
10.0.4.6:6379> exit
[root@VM_8_24_centos ~]# 

Myslq数据库查看连接的客户端

[root@VM_8_24_centos ~]# mysql -uroot -h 10.0.4.3 -pyourpassword
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 38411
Server version: 5.6.28-cdb2016-log 20180130

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;
+-----------+------------------------------------------------------------------+----------+
| host_name | state                                                            | count(*) |
+-----------+------------------------------------------------------------------+----------+
|           |                                                                  |        2 |
| 10.2.8.24 | executing                                                        |        1 |
|           | Master has sent all binlog to slave; waiting for binlog to be up |        1 |
+-----------+------------------------------------------------------------------+----------+
3 rows in set (0.00 sec)

MySQL [(none)]> exit
Bye
[root@VM_8_24_centos ~]# 

PostgreSQL查看连接的客户端

[root@VM_8_24_centos ~]# psql -h 10.0.4.5 -U postgresadmin -d postgres
Password for user postgresadmin: 
psql (9.2.24, server 9.5.4)
WARNING: psql version 9.2, server version 9.5.
         Some psql features might not work.
Type "help" for help.

postgres=> select * from pg_stat_activity;
 datid | datname  |  pid  | usesysid |    usename    | application_name | client_addr | client_hostname | client_port |        backend_
start         |          xact_start           |          query_start          |         state_change          | waiting | state  | back
end_xid | backend_xmin |              query              
-------+----------+-------+----------+---------------+------------------+-------------+-----------------+-------------+----------------
--------------+-------------------------------+-------------------------------+-------------------------------+---------+--------+-----
--------+--------------+---------------------------------
 13295 | postgres | 37774 |       10 | postgres      |                  |             |                 |             |                
              |                               |                               |                               |         |        |     
        |              | <insufficient privilege>
 13295 | postgres | 16485 |       10 | postgres      |                  |             |                 |             |                     
         |                               |                               |                               |         |        |             | 
             | <insufficient privilege>
 13295 | postgres | 16539 |    16384 | postgresadmin | psql             | 10.2.8.24   |                 |       56434 | 2019-03-21 10:28:44.
91409+08 | 2019-03-21 10:28:58.604402+08 | 2019-03-21 10:28:58.604402+08 | 2019-03-21 10:28:58.604405+08 | f       | active |             | 
        1837 | select * from pg_stat_activity;
(3 rows)

postgres-> \q
[root@VM_8_24_centos ~]# 

转载于:https://blog.51cto.com/jerrymin/2366480