MySQL运维信息 àì夳堔傛蜴生んèń 2021-12-19 00:49 265阅读 0赞 **第一:查看所有连接的客户端IP** SELECT substring_index(HOST, ':', 1) AS host_name, state, count(*) FROM information_schema.PROCESSLIST GROUP BY state, host_name; ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70][] **第二:查看所有的连接信息** SELECT * FROM information_schema.PROCESSLIST ; ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70 1][] **第三:查看一个SQL最终需要查询多少条数据** EXPLAIN SELECT * FROM gov_price gp WHERE gp.city='长沙市' ; EXPLAIN 关键字 ![2019070121403650.png][] [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70]: /images/20211219/b69302df3cd54c888c835d79ae5126c0.png [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70 1]: /images/20211219/2c4681bc70cd447a90faf5c0ca25070a.png [2019070121403650.png]: /images/20211219/4031ffbc4a6643d5bd8d9466a2ffb321.png
还没有评论,来说两句吧...