一、 基础与连接优化

先说说我们需要对Apache2进行一些基础配置的优化，以提升网站访问速度。

sudo a2enmod deflate

染后 在配置文件中加入以下内容：

    AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css application/javascript application/json application/x-javascript text/css application/javascript application/xml application/xml+rss text/javascript application/javascript text/javascript text/xml text/xml+rss

我们都经历过... 接下来我们来堪一下数据库优化。为高频查询建立合适索引、优化慢查询、合理设置缓冲，减少后端瓶颈对 Apache 的影响。

二、缓存策略

妥妥的！ 缓存是提高网站访问速度的关键。 sudo a2enmod expires 配置示例： ExpiresActive On ExpiresByType image/jpg "access plus 1 month" ExpiresByType image/jpeg "access plus 1 month" ExpiresByType image/gif "access plus 1 month" ExpiresByType image/png "access plus 1 month" ExpiresByType text/css "access plus 1 week" ExpiresByType application/javascript "access plus 1 week" ExpiresByType application/x-javascript "access plus 1 week" ExpiresByType application/xml "access plus 1 week" ExpiresByType application/xhtml+xml "access plus 1 week" ExpiresByType image/x-icon "access plus 1 week" ExpiresByType text/html "access plus 1 day" ExpiresByType text/plain "access plus 1 day" ExpiresByType text/xml "access plus 1 day" ExpiresByType application/xml "access plus 1 day" ExpiresByType application/xml+rss "access plus 1 day" ExpiresByType application/json "access plus 1 day" ExpiresByType application/javascript "access plus 1 day" ExpiresByType application/x-font-ttf "access plus 1 day" ExpiresByType application/x-font-opentype "access plus 1 day" ExpiresByType application/x-font-woff "access plus 1 day" ExpiresByType application/x-font-woff2 "access plus 1 day" ExpiresByType application/font-woff "access plus 1 day" ExpiresByType application/font-woff2 "access plus 1 day" ExpiresByType application/font-ttf "access plus 1 day" ExpiresByType application/font-opentype "access plus 1 day" ExpiresByType application/octet-stream "access plus 1 day" ExpiresByType application/x-shockwave-flash "access plus 1 day" ExpiresByType application/pdf "access plus 1 day" ExpiresByType application/x-pdf "access plus 1 day" ExpiresByType application/x-flash "access plus 1 day" ExpiresByType application/x-flash4 "access plus 1 day" ExpiresByType application/x-flash5 "access plus 1 day" ExpiresByType application/x-flash6 "access plus 1 day" ExpiresByType application/x-flash7 "access plus 1 day" ExpiresByType application/x-flash8 "access plus 1 day" ExpiresByType application/x-flash9 "access plus 1 day" ExpiresByType application/x-flash10 "access plus 1 day" ExpiresByType application/x-flash11 "access plus 1 day" ExpiresByType application/x-flash12 "access plus 1 day" ExpiresByType application/x-flash13 "access plus 1 day" ExpiresByType application/x-flash14 "access plus 1 day" ExpiresByType application/x-flash15 "access plus 1 day" ExpiresByType application/x-flash16 "access plus 1 day" ExpiresByType application/x-flash17 "access plus 1 day" ExpiresByType application/x-flash18 "access plus 1 day" ExpiresByType application/x-flash19 "access plus 1 day" ExpiresByType application/x-flash20 "access plus 1 day" ExpiresByType application/x-flash21 "access plus 1 day" ExpiresByType application/x-flash22 "access plus 1 day" ExpiresByType application/x-flash23 "access plus 1 day" ExpiresByType application/x-flash24 "access plus 1 day" ExpiresByType application/x-flash25 "access plus 1 day" ExpiresByType application/x-flash26 "access plus 1 day" ExpiresByType application/x-flash27 "access plus 1 day" ExpiresByType application/x-flash28 "access plus 1 day" ExpiresByType application/x-flash29 "access plus 1 day" ExpiresByType application/x-flash30 "access plus 1 day" ExpiresByType application/x-flash31 "access plus 1 day" ExpiresByType application/x-flash32 "access plus 1 day" ExpiresByType application/x-flash33 "access plus 1 day" ExpiresByType application/x-flash34 "access plus 1 day" ExpiresByType application/x-flash35 "access plus 1 day" ExpiresByType application/x-flash36 "access plus 1 day" ExpiresByType application/x-flash37 "access plus 1 day" ExpiresByType application/x-flash38 "access plus 1 day" ExpiresByType application/x-flash39 "access plus 1 day" ExpiresByType application/x-flash40 "access plus 1 day" ExpiresByType application/x-flash41 "access plus 1 day" ExpiresByType application/x-flash42 "access plus 1 day" ExpiresByType application/x-flash43 "access plus 1 day" ExpiresByType application/x-flash44 "access plus 1 day" ExpiresByType application/x-flash45 "access plus 1 day" ExpiresByType application/x-flash46 "access plus 1 day" ExpiresByType application/x-flash47 "access plus 1 day" ExpiresByType application/x-flash48 "access plus 1 day" ExpiresByType application/x-flash49 "access plus 1 day" ExpiresByType application/x-flash50 "access plus 1 day" ExpiresByType application/x-flash51 "access plus 1 day" ExpiresByType application/x-flash52 "access plus 1 day" ExpiresByType application/x-flash53 "access plus 1 day" ExpiresByType application/x-flash54 "access plus 1 day" ExpiresByType application/x-flash55 "access plus 1 day" ExpiresByType application/x-flash56 "access plus 1 day" ExpiresByType application/x-flash57 "access plus 1 day" ExpiresByType application/x-flash58 "access plus 1 day" ExpiresByType application/x-flash59 "access plus 1 day" ExpiresByType application/x-flash60 "access plus 1 day" ExpiresByType application/x-flash61 "access plus 1 day" ExpiresByType application/x-flash62 "access plus 1 day" ExpiresByType application/x-flash63 "access plus 1 day" ExpiresByType application/x-flash64 "access plus 1 day" ExpiresByType application/x-flash65 "access plus 1 day" ExpiresByType application/x-flash66 "access plus 1 day" ExpiresByType application/x-flash67 "access plus 1 day" ExpiresByType application/x-flash68 "access plus 1 day" ExpiresByType application/x-flash69 "access plus 1 day" ExpiresByType application/x-flash70 "access plus 1 day" ExpiresByType application/x-flash71 "access plus 1 day" ExpiresByType application/x-flash72 "access plus 1 day" ExpiresByType application/x-flash73 "access plus 1 day" ExpiresByType application/x-flash74 "access plus 1 day" ExpiresByType application/x-flash75 "access plus 1 day" ExpiresByType application/x-flash76 "access plus 1 day" ExpiresByType application/x-flash77 "access plus 1 day" ExpiresByType application/x-flash78 "access plus 1 day" ExpiresByType application/x-flash79 "access plus 1 day" ExpiresByType application/x-flash80 "access plus 1 day" ExpiresByType application/x-flash81 "access plus 1 day" ExpiresByType application/x-flash82 "access plus 1 day" ExpiresByType application/x-flash83 "access plus 1 day" ExpiresByType application/x-flash84 "access plus 1 day" ExpiresByType application/x-flash85 "access plus 1 day" ExpiresByType application/x-flash86 "access plus 1 day" ExpiresByType application/x-flash87 "access plus 1 day" ExpiresByType application/x-flash88 "access plus 1 day" ExpiresByType application/x-flash89 "access plus 1 day" ExpiresByType application/x-flash90 "access plus 1 day" ExpiresByType application/x-flash91 "access plus 1 day" ExpiresByType application/x-flash92 "access plus 1 day" ExpiresByType application/x-flash93 "access plus 1 day" ExpiresByType application/x-flash94 "access plus 1 day" ExpiresByType application/x-flash95 "access plus 1 day" ExpiresByType application/x-flash96 "access plus 1 day" ExpiresByType application/x-flash97 "access plus 1 day" ExpiresByType application/x-flash98 "access plus 1 day" ExpiresByType application/x-flash99 "access plus 1 day" ExpiresByType application/x-flash100 "access plus 1 day" ExpiresByType application/x-flash101 "access plus 1 day" ExpiresByType application/x-flash102 "access plus 1 day" ExpiresByType application/x-flash103 "access plus 1 day" ExpiresByType application/x-flash104 "access plus 1 day" ExpiresByType application/x-flash105 "access plus 1 day" ExpiresByType application/x-flash106 "access plus 1 day" ExpiresByType application/x-flash107 "access plus 1 day" ExpiresByType application/x-flash108 "access plus 1 day" ExpiresByType application/x-flash109 "access plus 1 day" ExpiresByType application/x-flash110 "access plus 1 day" ExpiresByType application/x-flash111 "access plus 1 day" ExpiresByType application/x-flash112 "access plus 1 day" ExpiresByType application/x-flash113 "access plus 1 day" ExpiresByType application/x-flash114 "access plus 1 day" ExpiresByType application/x-flash115 "access plus 1 day" ExpiresByType application/x-flash116 "access plus 1 day" ExpiresByType application/x-flash117 "access plus 1 day" ExpiresByType application/x-flash118 "access plus 1 day" ExpiresByType application/x-flash119 "access plus 1 day" ExpiresByType application/x-flash120 "access plus 1 day" ExpiresByType application/x-flash121 "access plus 1 day" ExpiresByType application/x-flash122 "access plus 1 day" ExpiresByType application/x-flash123 "access plus 1 day" ExpiresByType application/x-flash124 "access plus 1 day" ExpiresByType application/x-flash125 "access plus 1 day" ExpiresByType application/x-flash126 "access plus 1 day" ExpiresByType application/x-flash127 "access plus 1 day" ExpiresByType application/x-flash128 "access plus 1 day" ExpiresByType application/x-flash129 "access plus 1 day" ExpiresByType application/x-flash130 "access plus 1 day" ExpiresByType application/x-flash131 "access plus 1 day" ExpiresByType application/x-flash132 "access plus 1 day" ExpiresByType application/x-flash133 "access plus 1 day" ExpiresByType application/x-flash134 "access plus 1 day" ExpiresByType application/x-flash135 "access plus 1 day" ExpiresByType application/x-flash136 "access plus 1 day" ExpiresByType application/x-flash137 "access plus 1 day" ExpiresByType application/x-flash138 "access plus 1 day" ExpiresByType application/x-flash139 "access plus 1 day" ExpiresByType application/x-flash140 "access plus 1 day" ExpiresByType application/x-flash141 "access plus 1 day" ExpiresByType application/x-flash142 "access plus 1 day" ExpiresByType application/x-flash143 "access plus 1 day" ExpiresByType application/x-flash144 "access plus 1 day" ExpiresByType application/x-flash145 "access plus 1 day" ExpiresByType application/x-flash146 "access plus 1 day" ExpiresByType application/x-flash147 "access plus 1 day" ExpiresByType application/x-flash148 "access plus 1 day" ExpiresByType application/x-flash149 "access plus 1 day" ExpiresByType application/x-flash150 "access plus 1 day" ExpiresByType application/x-flash151 "access plus 1 day" ExpiresByType application/x-flash152 "access plus 1 day" ExpiresByType application/x-flash153 "access plus 1 day" ExpiresByType application/x-flash154 "access plus 1 day" ExpiresByType application/x-flash155 "access plus 1 day" ExpiresByType application/x-flash156 "access plus 1 day" ExpiresByType application/x-flash157 "access plus 1 day" ExpiresByType application/x-flash158 "access plus 1 day" ExpiresByType application/x-flash159 "access plus 1 day" ExpiresByType application/x-flash160 "access plus 1 day" ExpiresByType application/x-flash161 "access plus 1 day" ExpiresByType application/x-flash162 "access plus 1 day" ExpiresByType application/x-flash163 "access plus 1 day" ExpiresByType application/x-flash164 "access plus 1 day" ExpiresByType application/x-flash165 "access plus 1 day" ExpiresByType application/x-flash166 "access plus 1 day" ExpiresByType application/x-flash167 "access plus 1 day" ExpiresByType application/x-flash168 "access plus 1 day" ExpiresByType application/x-flash169 "access plus 1 day" ExpiresByType application/x-flash170 "access plus 1 day" ExpiresByType application/x-flash171 "access plus 1 day" ExpiresByType application/x-flash172 "access plus 1 day" ExpiresByType application/x-flash173 "access plus 1 day" ExpiresByType application/x-flash174 "access plus 1 day" ExpiresByType application/x-flash175 "access plus 1 day" ExpiresByType application/x-flash176 "access plus 1 day" ExpiresByType application/x-flash177 "access plus 1 day" ExpiresByType application/x-flash178 "access plus 1 day" ExpiresByType application/x-flash179 "access plus 1 day" ExpiresByType application/x-flash180 "access plus 1 day" ExpiresByType application/x-flash181 "access plus 1 day" ExpiresByType application/x-flash182 "access plus 1 day" ExpiresByType application/x-flash183 "access plus 1