mysql王者之路_MySQL运维实战（二）之 巧用P_S解决账号host访问的荣耀王者之路

*使用案例

dba:performance_schema> select USER,EVENT_NAME,COUNT_STAR,now() as time from events_statements_summary_by_user_by_event_name where EVENT_NAME in ('statement/sql/select','statement/sql/update','statement/sql/delete','statement/sql/insert','statement/sql/replace') and COUNT_STAR > 0; +------+----------------------+------------+---------------------+

| USER | EVENT_NAME | COUNT_STAR | time | +------+----------------------+------------+---------------------+

| dba | statement/sql/select | 143 | 2017-09-04 18:02:33 |

| repl | statement/sql/select | 10 | 2017-09-04 18:02:33 | +------+----------------------+------------+---------------------+

2 rows in set (0.00 sec)

dba:performance_schema> select HOST,EVENT_NAME,COUNT_STAR,now() as time from events_statements_summary_by_host_by_event_name where EVENT_NAME in ('statement/sql/select','statement/sql/update','statement/sql/delete','statement/sql/insert','statement/sql/replace') and COUNT_STAR > 0; +-----------+----------------------+------------+---------------------+

| HOST | EVENT_NAME | COUNT_STAR | time | +-----------+----------------------+------------+---------------------+

| localhost | statement/sql/select | 22 | 2017-09-04 18:02:35 | +-----------+----------------------+------------+---------------------+

1 row in set (0.00 sec)