#mysql查看连接数
SHOW VARIABLES like '%max_connections% ';
# max_connections Maximum number of connections
SHOW VARIABLES like '%connection% ';
# processlist;
# to judge by observing SQL.
SHOW Full Processlist
SHOW processlist;
SHOW STATUS;
SHOW processlist
#show Extended-status;
SHOW STATUS like '%connect% '; # 1219
# Connections attempts to connect to (regardless of success) the total number of connections to the MySQL server
# threads_connected Current number of connections
# max_used_connections Maximum number of connections (concurrent) that have been used since the server started
Log analysis, request interface:
Cat Statxx.2017-04-01.*.log | Grep-c 5 ' requri:/vx/chx/supx ';
Cat Auxx-2017-04-01-*.log | Grep-c 5 '/vx/chx/support ';
Cat Auxx-error.2017-04-01.*.log | Grep-c 5 '/vx/chx/supx ';
Auxx-2017-04-01 a new log
2017-04-01 08:33:28.414 [http-nio-7064-exec-7] INFO com.auxx.filter.verxfilter#dofilter [line:52]-User-Agent: autoyol_49:android_23|
640bb43dc8ffe2a7323718ca9be10674d30c3e3031dd223d3333333333, Requri:/vx/chx/supx (' POST ' from 118.255.29.100)
Statxx.2017-04-01 the old log
2017-04-01 11:57:32.698 [http-nio-7065-exec-7] INFO c.a.interceptor.defaultinterceptor#prehandle [line:126]- user-agent:autoyol_48:iphone_10.2.1|
98c82a94f57ad7cae1cbadc404b9bf1d3ea5edeaaa657a6117f426d42fd108c6a030b76b4b8e69, ReqUri:/traxx/v7x/reqxx (' POST ' From 59.42.108.63)
2017-04-01
MySQL view number of connections troubleshooting