åå説æãããã¨
- OSãªã½ã¼ã¹ã大ã¾ãã«åããã¨ãCPUãã¡ã¢ãªãã¹ãã¬ã¼ã¸ããããã¯ã¼ã¯ã®4ã¤
- CPUã¨ã¡ã¢ãªã®ä½¿ç¨ç¶æ³ã«ã¤ãã¦ãã©ã®ãããªè¦³ç¹ããåæãè¡ã£ã¦ããã
注æ
- æ¬ç¨¿ã®åä½ç¢ºèªç°å¢ã¯ãRed Hat Enterprise Linux 6.4ï¼ä»¥ä¸ãRHEL6.4ï¼ï¼sysstat9.0.4ã§ãã
- sysstatããã±ã¼ã¸ãã¤ã³ã¹ãã¼ã«æ¸ã¿ã§ãããã¨ãåæã§ãã
- æ¬ç¨¿ã«åºã¥ãéç¨ã«ã¤ãã¦ã¯ãã客æ§èªèº«ã®è²¬ä»»ã¨å¤æã«ãã£ã¦è¡ã£ã¦ãã ããã
ã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã®æ§è½é¢ã«ãããç¹å¾´
æåã«ãã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã®æ§è½é¢ã«é¢ããç¹å¾´ãææ¡ãã¦ããã¾ãããã
ãåãã®ããã«ãã¹ãã¬ã¼ã¸ããããã¯ã¼ã¯ã®å¦çæéã¯ãCPUãã¡ã¢ãªã¨ã¯æ¯è¼ã«ãªããªãã»ã©ä½éã§ãããã®ããããã¼ãã¦ã§ã¢å´ã¨OSå´ã®åæ¹ã§å ¥åºåãå¹çåãã工夫ãããã¦ãã¾ããä¾ãã°ããããã¡ãªã³ã°ããã£ãã·ã¥ãå¦çã®ä¸¦ååãªã©ãæãããã¾ãããããã®ãã¡å¦çã®ä¸¦ååã®ä¾ã¨ãã¦ã¯ãã¹ãã¬ã¼ã¸ã§ã¯RAIDï¼è¤æ°ã®ãã£ã¹ã¯ã§I/Oå¦çãåæ£ï¼ãã³ãã³ããã¥ã¼ã¤ã³ã°ï¼1ã¤ã®ãã£ã¹ã¯ã§åæã«è¤æ°I/Oãå¦çï¼ããããã¯ã¼ã¯ã§ã¯Bondingï¼è¤æ°ã®NICããããã¯ã¼ã¯ã¤ã³ã¿ãã§ã¼ã¹ã«ã¼ããã§éä¿¡å¦çãåæ£ï¼ããã«ããã¥ã¼NICï¼1ã¤ã®NICã§éä¿¡å¦çãè¤æ°ã®CPUã¸åæ£ï¼ãªã©ãç¥ããã¦ãã¾ãã
ç¹ã«ã¹ãã¬ã¼ã¸ã¯ã·ã¹ãã ãæ§æãããã¼ãã¦ã§ã¢é¨åã®ä¸ã§æãä½éã§ãããããæ§è½åé¡ã®æ¸©åºï¼ãããã¹ãããï¼ã«ãªããã¡ã§ãããã®ãããªèæ¯ãããè¿å¹´ã§ã¯ã¹ãã¬ã¼ã¸ã«SSD製åãæ¡ç¨ãããããããã¯ãªã³ã¡ã¢ãªåããã£ãã·ã¥ãµã¼ããå©ç¨ãããªã©ã極åé«éãªããã¤ã¹ãç¨ãããã¨ã§ã¹ãã¬ã¼ã¸ã®ããã«ããã¯è§£æ¶ãè¡ããã¨ããã¬ã³ãã«ãªã£ã¦ãã¦ãã¾ãããããã¯ã¼ã¯ã«ã¤ãã¦ã¯ãã®ã¬ããã以ä¸ã®é信帯åã主æµã¨ãªã£ããã¨ã§ããã¼ãã¦ã§ã¢çã«ã¯é«éãªç°å¢ãå®ç¾ããã¤ã¤ããã¾ãã
ã¨ã¯ãããI/Oå¦çï¼ã¹ãã¬ã¼ã¸é¢é£ï¼ãããã¯éä¿¡å¦çï¼ãããã¯ã¼ã¯é¢é£ï¼ã§æ§è½åé¡ãå¼ãèµ·ããã¦ããã·ã¹ãã ã¯å¾ã絶ã¡ã¾ããããã®ä¸ã§ãç´æ¥ã®åå ããã¼ãã¦ã§ã¢ã®ã¹ããã¯ä¸è¶³ã¨ããã±ã¼ã¹ã¯å°ãªãã§ããããããè¨å®ãå¦çæ¹å¼ï¼ã¢ããªã±ã¼ã·ã§ã³å®è£ ãªã©ï¼ã«èµ·å ãã¦ããã±ã¼ã¹ã®ã»ããå¤ãå¾åãè¦ããã¾ãã
ã¾ããã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã®æ§è½ã«é¢ãã¦ã¯ãããã©ã¼ãã³ã¹åæãé£ããã¨ããå´é¢ãããã¾ãã両è ã®æ§è½ã«ã¯ãOSå é¨ã ãã§ãªãå¤é¨ã®æ©å¨ãå«ãã¦è¤æ°ã®ã¬ã¤ã¤ã¼ãé¢é£ãã¦ãããåä½ãç´°é¨ã¾ã§ææ¡ãããã¨ã容æã§ã¯ãªãããã§ããåºæ¬çãªæ§è½ãããã¼ãã¦ã§ã¢é¨åã®ã¹ããã¯ã§æ±ºã¾ãCPUãã¡ã¢ãªã¨ã¯ãã®ç¹ã§å¯¾ç §çã§ãã
ã§ã¯ãã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã®ããã©ã¼ãã³ã¹åæã¯ãã©ã®ããã«è¡ãã°ããã®ããããããé ã追ã£ã¦è§£èª¬ãã¾ãã
ããã©ã¼ãã³ã¹åæã®èãæ¹
ã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã¯ãOSããã¯ããã¤ã¹ãã©ã¤ããçµç±ãã¦ãå ¥åºåããè¡ãããã¨ããç¹å¾´ãããã¾ããããã§ãã¹ãã¬ã¼ã¸ããããã¯ã¼ã¯ãã®ãã®ããµãã·ã¹ãã ï¼ãµã¼ãã¹ï¼ã¨ã¿ãªãã¾ããããã«ãããããã©ã¼ãã³ã¹åæã®èãæ¹ãã·ã³ãã«ã«ãªãã¾ãã
ä¾ãã°ããã©ã¦ã¶ã§Webãµã¼ãã¹ã«ã¢ã¯ã»ã¹ããã¨ãWebãµã¼ãã¹ã«å¯¾ãã¦è¦æ±ï¼å ¥åï¼ãè¡ããããã®è¦æ±ãå¦çãããå¾ã«å¿çï¼åºåï¼ããã©ã¦ã¶ã«è¿ã£ã¦ãã¾ãããã®ã¨ããWebãµã¼ãã¹ã®æ§è½ã¨ãã¦çç®ããã®ã¯ãã¹ã«ã¼ãããï¼ã©ã®ç¨åº¦ã®è¦æ±æ°ããã°ãããï¼ãã¨ããã®ãå¿çæéãã§ããã¹ãã¬ã¼ã¸ããããã¯ã¼ã¯ã«ã¤ãã¦ããããã¨åæ§ãªè¦æ¹ãã§ãã¾ãã
ã¤ã¾ããCPUã§ã¯ã使ç¨çããã¡ã¢ãªã§ã¯ã使ç¨éããããã©ã¼ãã³ã¹åæã®ææ¨ã«ãªãã®ã«å¯¾ããã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã§ã¯ã¹ã«ã¼ãããããã³å¿çæéãããã©ã¼ãã³ã¹åæã®ææ¨ã¨ãªãã¾ãã
ãªããã¹ãã¬ã¼ã¸ã«ã¯æ ¼ç´å®¹éã¨ããæå³ã§ã使ç¨éãã®ææ¨ãããã¾ãããé常ã¯æ§è½ã«ç´æ¥é¢ä¿ããªããã[1]ãæ¬ç¨¿ã§ã¯è§£èª¬ãå²æãã¾ãã
注
[1]: ã¹ãã¬ã¼ã¸ã®ç©ºã容éã極端ã«ä¸è¶³ãã¦ããå ´åã«ã¯æ³¨æãå¿ è¦ã§ããã·ã¹ãã ãä¸å®å®ã«ãªãå±éºæ§ãããã»ããé åå²ãå½ã¦ã®ããã«ã©ã¤ãï¼æ¸ãè¾¼ã¿ï¼æ§è½ãä½ä¸ãããã¨ãããã¾ãã
ã¹ã«ã¼ãããã¨å¿çæéã«ã¤ãã¦
ã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã«ããã¦ãã¹ã«ã¼ãããã¯ãå¦çããæ°ï¼I/Oæ°ãéä¿¡ãã±ããæ°ï¼ã¨è»¢ééï¼ãã¤ãåä½ï¼ã«åé¡ããã¾ããã¾ãå¿çæéã¯ãå¦çä¸ã®æéã¨å¦çå¾ ã¡ã®æéï¼å¾ ã¡è¡åæéããã¥ã¼å¾ ã¡æéã¨ãããï¼ã«åé¡ããã¾ãã
ç¹ã«ãã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã®ããã©ã¼ãã³ã¹åæã§å¤§äºãªã®ã¯ãå¾ ã¡è¡åã¨ããèãæ¹ã§ãã
I/Oå¦çï¼ã¹ãã¬ã¼ã¸é¢é£ï¼ãããã¯éä¿¡å¦çï¼ãããã¯ã¼ã¯é¢é£ï¼ãè¡ãéãOSå é¨ã ãã§ãªãå¤é¨ã®æ©å¨ãå«ããåæã«å¦çã§ããéã«ã¯éããããã¾ãããããè¶ ããå¦çè¦æ±ã¯å¦çå¾ ã¡ã«ãªã£ã¦ãã¾ãã¾ããã¹ãã¬ã¼ã¸ããããã¯ã¼ã¯ã®ãªã½ã¼ã¹ã使ãåã£ã¦ãã¾ãã°ï¼ãã¼ãã¦ã§ã¢ã®æ§è½éçã«éããã°ï¼ãå½ç¶ãªããã¹ã«ã¼ãããã¯ãã以ä¸åºã¾ãããå¦çå¾ ã¡ã®æéãå¢å ããä¸æ¹ã§ããã¤ã¡ã¼ã¸ã¨ãã¦ã¯ãæ··éããã³ã³ããã§ã¬ã¸å¾ ã¡ã®ã客ããã®è¡åãã§ãã¦ããç¶æ³ã§ãã
ä¸æ¹ã§ããªã½ã¼ã¹ããã»ã©ä½¿ããã¦ããªãã«ãããããããã¹ã«ã¼ããããåºãªãã±ã¼ã¹ãããã¾ããããã«ã¯2ã¤ã®å ¸åçãªãã¿ã¼ã³ãããã¾ããã©ã¡ããå¦çæ¹å¼ï¼ã¢ããªã±ã¼ã·ã§ã³å®è£ ãªã©ï¼ã«å¯æ¥ã«é¢ä¿ãã¦ãã¾ãã
- 1ï¼ããã¯ã«ããæä»å¶å¾¡ã®ãããåæã«1ã¤ããå¦çã§ããªãï¼åæå®è¡æ°ãå¤ãå ´åããã®å¯è½æ§ãé«ãï¼
- 2ï¼å¦çãªã¼ãã¼ããããããã¯ã¨ãªãããªããªãå¦çãé²ã¾ãªãï¼åæå®è¡æ°ãå°ãªãå ´åããã®å¯è½æ§ãé«ãï¼
1ï¼ã®ä»£è¡¨ä¾ã¯ããã¼ã¿ãã¼ã¹ã®è¡ããã¯ã«ãã競åå¾ ã¡ãã§ããåæã«è¤æ°ã®å¦çãå½è©²ããã¯ãåãåããã¨ããå ´åãæ©ãè åã¡ã«ãªãã¾ããå¾ç¶ã®å¦çã¯ããã¯ã解æ¾ãããã¾ã§å¾ ãããã¾ãã
2ï¼ã¯ãéä¿¡ãã¼ã¿ãç´°åãã«ãããã¯ã¼ã¯è»¢éããå¦çæ¹å¼ãã1ã¤ã®SQLæã§ä¸æ¬å¦çã§ããã®ã«ã«ã¼ãå å¦çã§SQLæã大éçºè¡ãã¦ããå¦çæ¹å¼ãªã©ã該å½ãã¾ããã¡ããã©ãã³ã³ããã§è¤æ°ã®ååãè²·ããã¨ããã客ããããåå1ã¤1ã¤ãã¬ã¸ã«ä¸¦ã³ç´ãã¦ç²¾ç®ãã¦ãããããªç¶æ³ã§ãããªãã¨éå¹çãªâ¦â¦ãã¨æãããããããã¾ãããããã®ãããªå¦çæ¹å¼ã¨ãªã£ã¦ããã·ã¹ãã ã¯æ¡å¤å¤ãã§ãããªã½ã¼ã¹ã¯ã¹ã«ã¹ã«ã§ï¼ç©ºãã¦ãã¦ï¼ãããã¯ã«ããæä»å¶å¾¡ãç¹ã«ãªãã¯ããªã®ã«ããªãæ§è½ãåºãªãã®ã ããâ¦â¦ã¨ããå ´åããã®ãã¿ã¼ã³ã§ããã¨èãããã¾ãã
ã¾ã¨ããã¨ãã¹ãã¬ã¼ã¸ã¨ãããã¯ã¼ã¯ã®ããã©ã¼ãã³ã¹åæãè¡ãéã®ãã¤ã³ãã¯æ¬¡ã®2ã¤ã§ãã
- ã¹ã«ã¼ãããããã¼ãã¦ã§ã¢ã®æ§è½éçã«éãã¦ãããï¼ãªã½ã¼ã¹ãã©ã®ç¨åº¦ä½¿ã£ã¦ãããï¼
- å¿çæéãé 延ãã¦ãããï¼å¦çä¸ã¨å¦çå¾ ã¡ã®ã©ã¡ãã«æéãããã£ã¦ãããï¼
å ·ä½çã«ã¯ããOSãªã½ã¼ã¹ã®ä½¿ç¨ç¶æ³ã確èªããããã«ããã¯ã®çãããããï¼ãããã¯ã©ã®ç¨åº¦ã®è² è·ã¾ã§èããããããï¼ããå¤æãããã¨ã«ãªãã¾ãã
ãã®ããã«ããã¯ã®æå¨ã¯ãOSå é¨ã¨ãããã¨ãããã°ãå¤é¨ã®æ©å¨ã¨ããå¯è½æ§ãããã¾ãããã®ãããOSä¸ã§è¨æ¸¬ã§ãããªã½ã¼ã¹ä½¿ç¨ç¶æ³ã ãã§ãªããé¢é£ããæ§è½æ å ±ã確èªããªããã°ãªããªããã¨ãããã¾ããä¾ãã°ãã¹ãã¬ã¼ã¸ã«ã¯å¤é¨ã¹ãã¬ã¼ã¸å´ã®æ§è½æ å ±ãããããããã¯ã¼ã¯ã«ã¯ãããã¯ã¼ã¯æ©å¨ãéä¿¡å ãã·ã³å´ã®æ§è½æ å ±ãããã¾ããã¾ãããã¼ã¿ãã¼ã¹è£½åãã¢ããªã±ã¼ã·ã§ã³ãµã¼ã製åã®ä¸ã«ã¯ãI/OéãI/Oå¾ ã¡æéããããã¯ã¼ã¯è»¢ééãéä¿¡å¾ ã¡æéãè¨æ¸¬ã§ãããã®ãããã¾ãã
OSãªã½ã¼ã¹ã®ããã©ã¼ãã³ã¹åæãè¡ã£ãå¾ã«ã¯ã詳細ãªããã«ããã¯èª¿æ»ãè¡ããããããããé¢é£ããæ§è½æ å ±ã確èªãã¾ãããã