August 2017
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
28293031  

Categories

August 2017
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
28293031  

MySQL InnoDB engine B + tree index simple finishing instructions

There are several types of InnoDB engine tables in MySQL (the following index, no special instructions, refers to the InnoDB engine table index.) 0 = Secondary Index, 2-level index, 1 = Clustered Index, clustered index 2 = Unique Index, Unique Index 3 = Primary Index, Primary Key Index 32 = Full-text Index, Full Index 64 […]

Nginx server 10000 concurrent optimization test (ab test tool)

1.nginx monitoring module

1) Compile nginx with the parameter –with-http_stub_status_module

#/usr/local/nginx/sbin/nginx -V ./configure –user=www –group=www –prefix=/usr/local/nginx –with-http_stub_status_module –with-http_ssl_mo ./configure –prefix=/usr/local –user=nginx –group=nginx –with-http_ssl_module –with-http_realip_module –http-client-body-temp-path=/usr/local/var/tmp/nginx/client –http-proxy-temp-path=/usr/local/var/tmp/nginx/proxy –http-fastcgi-temp-path=/usr/local/var/tmp/nginx/fcgi –http-scgi-temp-path=/usr/local/var/tmp/nginx/scgi –http-uwsgi-temp-path=/usr/local/var/tmp/nginx/uwsgi –with-http_geoip_module –with-http_stub_status_module

2) Modify the nginx configuration file and add the monitoring status configuration

Add the following code to the server block of nginx.conf

location /nginx_status […]

Linux server found strange port handling methods

Generally in the beginning of the need for their own company’s IT environment to have a general understanding of 1-2 months after the need to open the port has a clear understanding of what the port is used to do, whether it is illegal open port , Their own mind to be the number of […]