show processlist

mysql> show processlist; #mysql服务器查看有那些主机连进来，并列出它们查什么库+-----+------+-----------+------+---------+------+-------+------------------+| Id | User | Host   | db  | Command | Time | State | Info       |+-----+------+-----------+------+---------+------+-------+------------------+| 516 | root | localhost | NULL | Query  |  0 | NULL | show processlist |+-----+------+-----------+------+---------+------+-------+------------------+1 row in set (0.00 sec)

[root@bass ~]# ssh 192.168.1.89reverse mapping checking getaddrinfo for bogon [192.168.1.89] failed - POSSIBLE BREAK-IN ATTEMPT!root@192.168.1.89's password: Last login: Sun May 8 04:57:24 2016 from 192.168.1.10[root@v01 ~]# mysql -usx -p -h101.200.xx.xxEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 517Server version: 5.5.40-log MySQL Community Server (GPL)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database      |+--------------------+| information_schema || sx         || test        |+--------------------+3 rows in set (0.01 sec)

mysql> show processlist;+-----+------+----------------------+------+---------+------+-------+------------------+| Id | User | Host         | db  | Command | Time | State | Info       |+-----+------+----------------------+------+---------+------+-------+------------------+| 516 | root | localhost      | NULL | Query  |  0 | NULL | show processlist || 517 | sx  | 118.194.xxx.xxx:xxx | NULL | Sleep  |  28 |    | NULL       |+-----+------+----------------------+------+---------+------+-------+------------------+2 rows in set (0.00 sec)

mysql> use mysql;Database changedmysql> show tables;+---------------------------+| Tables_in_mysql      |+---------------------------+| columns_priv       || db            || event           || func           || general_log        || help_category       || help_keyword       || help_relation       || help_topic        || host           || ndb_binlog_index     || plugin          || proc           || procs_priv        || proxies_priv       || servers          || slow_log         || tables_priv        || time_zone         || time_zone_leap_second   || time_zone_name      || time_zone_transition   || time_zone_transition_type || user           |+---------------------------+24 rows in set (0.01 sec)mysql> show processlist;+-----+------+----------------------+-------+---------+------+-------+------------------+| Id | User | Host         | db  | Command | Time | State | Info       |+-----+------+----------------------+-------+---------+------+-------+------------------+| 516 | root | localhost      | mysql | Query  |  0 | NULL | show processlist || 517 | sx  | 118.194.xxx.xxx:2373 | NULL | Sleep  | 297 |    | NULL       |+-----+------+----------------------+-------+---------+------+-------+------------------+2 rows in set (0.00 sec)

原标题：show processlist

关键词：