ORACLE 索引
创建索引条件
1.列包含较大范围的值；
2.列包含大量空值；
3.在WHERE字句或联结条件中频繁使用一个或多个列
4.表相当大，但是预计多数的查询检索的行不到总行数的百分之二至百分之四
1.列包含较大范围的值；
2.列包含大量空值；
3.在WHERE字句或联结条件中频繁使用一个或多个列
4.表相当大，但是预计多数的查询检索的行不到总行数的百分之二至百分之四
Nginx Proxy & Load Balance & LNMP
Nginx Proxy Service E-commerce website Server 1: provide image request response ( apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / { proxy_pass http://192.168.199.187:80/; } location /bbs/ { proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$ { proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / { proxy_pass http://192.168.199.187:80/; proxy_set_header <parameter name> $host; (client requst the hostname ) proxy_set_header <parameter name> $remote_addr; ...
Comments
Post a Comment