泌採受富斤Mysql議恵諒參單晒SQL囂鞘
<貧匯准
和匯准>
閲窒斤揖匯方象恂嶷鹸殊沫?
哘喘嶄俶勣尖賠萱斤方象垂議恵諒貸辞?俶勣斤屢揖燕議恵諒?勝楚鹿嶄壓屢揖sql恵諒?匯肝戻函潤惚?受富斤方象垂議嶷鹸恵諒。聞喘mysql query cache
恬喘?臥儂産贋贋刈SELECT臥儂議猟云參式窟僕公人薩極議屢哘潤惚。泌惚昧朔辺欺匯倖屢揖議臥儂?捲暦匂貫臥儂産贋嶄嶷仟誼欺臥儂潤惚?遇音壅俶勣盾裂才峇佩臥儂。癖喘袈律?音窟伏方象厚仟議燕。輝燕厚個?淫凄燕潤更才燕方象?朔?臥儂産贋峙議屢購訳朕瓜賠腎。
臥儂産贋議麼勣歌方譜崔?
show variables like ‘%query_cache%’;
have_query_cache燕苧捲暦匂壓芦廾聞厮将塘崔阻互堀産贋
query_cache_size燕苧産贋曝寄弌?汽了葎M
query_cache_type議延楚峙貫0欺2?根吶蛍艶葎
0賜宀off?産贋購液?
1賜宀on?産贋嬉蝕?聞喘sql_no_cache議select茅翌?
2賜宀demand?峪嗤揮sql_cache議select囂鞘戻工互堀産贋?
壓 SHOW STATUS 嶄?低辛參酌篇臥儂産贋議來嬬?
| 延楚 | 根吶 |
|---|---|
| Qcache_queries_in_cache | 壓産贋嶄厮廣過議臥儂方朕 |
| Qcache_inserts | 瓜紗秘欺産贋嶄議臥儂方朕 |
| Qcache_hits | 産贋寡劔方方朕 |
| Qcache_lowmem_prunes | 咀葎髪富坪贋遇瓜貫産贋嶄評茅議臥儂方朕 |
| Qcache_not_cached | 短嗤瓜産贋議臥儂方朕 (音嬬瓜産贋議?賜喇噐 QUERY_CACHE_TYPE) |
| Qcache_free_memory | 臥儂産贋議腎椀坪贋悳方 |
| Qcache_free_blocks | 臥儂産贋嶄議腎椀坪贋翠議方朕 |
| Qcache_total_blocks | 臥儂産贋嶄議翠議悳方朕 |
紗cache蚊
Cache?互堀産贋?、Memory?坪贋?、Hard disk?啣徒?脅頁方象贋函汽圷?徽贋函堀業抜嗤載寄餓呟?格卆肝弓受議乏會。斤噐CPU栖傍?万辛參貫鉦宣徭失恷除議Cache互堀仇贋函方象?遇音頁貫坪贋才啣徒參詰叱倖方楚雫議堀業栖贋函方象。遇Cache嶄侭贋刈議方象?吏吏頁CPU勣郡鹸贋函議方象?嗤蒙協議字崙?賜殻會?栖隠屬Cache坪方象議凋嶄楕?Hit Rate?。咀緩?CPU贋函方象議堀業壓哘喘互堀産贋朔誼欺阻賞寄議戻互。咀葎繍方象亟秘互堀産贋議販暦喇Cache Manager減夭?侭參斤喘薩栖傍互堀産贋議坪否刃協頁峪響議。俶勣低恂議垢恬載富?殻會嶄議SQL囂鞘才岷俊恵諒DBMS扮短嗤蛍艶?卦指議潤惚匆心音竃嗤焚担餓艶。遇方象垂皆斌吏吏氏壓DB Server議塘崔猟周嶄戻工嚥Cache屢購議歌方?宥狛俐個万断?辛寞斤厘断議哘喘單晒Cache議砿尖。
<貧匯准
和匯准>