[ÀÌÇöö]´ÔÀÌ ³²±â½Å ±Û:
>-----------------------------------------
>´äº¯ÀÚ°¡ ±âº»ÀûÀ¸·Î Âü°íÇÒ ³»¿ëÀÔ´Ï´Ù.
>- ¹èÆ÷ÆÇ(¿É¼Ç) :
>- Ä¿³Î¹öÀü(¿É¼Ç) :
>- µ¥¸ó¹öÀü(¿¹:apache 1.3.27) :
>- µ¥¸ó¼³Ä¡À¯Çü(RPM/ÄÄÆÄÀÏ/±âŸ)
:
>-----------------------------------------
>*Áß¿ä:ÇÑ±Û ¹®ÀÚ°¡ Çϳªµµ ¾øÀ¸¸é ½ºÆÔÆäÀÌÁö·Î À̵¿ÇÕ´Ï´Ù(½ºÆÔ ÇÊÅ͸µ).
>
>¸îĥ° ²þ²þ °í¹ÎÇÏ´Ù.. »êÀÌ´Ô²².. Á¶¾ðÀ» ¾òÀ»¼ö ¹Û¿¡¼ ¾ø¾ú¼.. ¸îÀÚ
Àû½À´Ï´Ù..
>
>¸îÄ¥Àü ºÎÅÍ ¿î¿µÇÏ°í ÀÖ´Â ¼¹ö¿¡ ¾öû ¸¹Àº Á¢¼Ó·®À» º¸ÀÌ´Â ¼¹ö°¡
ÀÖ½À´Ï´Ù..
>
>ÇöÀç ±¸Á¶´Â ¸®´ª½º·Î 2´ëÀÇ ¾îÇø®ÄÉÀ̼Ç(¾ÕÀ¸·Î AP¼¹ö·Î ÁöĪÇÏ°Ú½À´Ï´Ù.)
¼¹ö¿Í(java) ±× ¹Ø´Ü¿¡ ¸®´ª½º DB¼¹ö 1´ë·Î(DB¿Í mysql) ¿¬µ¿µÇ¾î ±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.
AP¼¹ö 2´ë´Â ·Îµå¹ë··½ÌÀ» ÀÌ¿ëÇÑ (»ó¿ëÈ Á¦Ç°ÀÎF5 BIG-IP)¸¦ ÅëÇØ ºÎÇÏ ºÎ»ê
½Ã½ºÅÛÇüÅ·Π±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.
>
>AP¼¹ö´Â ¿ÜºÎ¿¡¼ TCPÇÁ·ÎÅäÄÝÀ» ±â¹ÝÀ¸·Î Çؼ 20010 Æ÷Æ®¸¦ ÀÌ¿ëÇؼ ¿ÜºÎÀÖ´Â °¢
Á¡Æ÷ÀÇ Å¬¶óÀ̾ðÆ®¿¡¼ Á¤º¸¸¦ ¹Þ¾Æµé¿© DB¼¹ö·Î ÀúÀåÇÏ°í ÇüÅÂÀÔ´Ï´Ù.
>
>
>ÇöÀç ¹®Á¦´Â ±×¹øÁÖ ÁÖ¸»ºÎÅÍ ¾öû³ª°Ô ¸¹Àº Á¢¼ÓÀÌ ´Ã¾î³ª¸é¼ (°ø°ÝÀº ¾Æ´Ñ°Í
°°½À´Ï´Ù ) AP¼¹ö°¡ Á¦´ë·Î Ŭ¶óÀ̾ðÆ®¿¡¼ 20010 Æ÷Æ®·Î Á¦´ë·Î Á¢¼ÓÇÒ¼ö ¾ø´Â ÇüÅ·Î
º¸ÀÔ´Ï´Ù.
>
>¾Æ·¡´Â AP¼¹öÀÇ Á¤º¸ÀÔ´Ï´Ù.
>
>top - 20:39:51 up 4:00, 3 users, load average: 0.03, 0.02, 0.04
>Tasks: 69 total, 1 running, 68 sleeping, 0 stopped, 0 zombie
>Cpu0 : 0.0% us, 0.0% sy, 0.0% ni, 98.7% id, 1.0% wa, 0.0% hi, 0.3%
si
>Cpu1 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0%
si
>Cpu2 : 0.7% us, 0.3% sy, 0.0% ni, 99.0% id, 0.0% wa, 0.0% hi, 0.0%
si
>Cpu3 : 0.7% us, 0.0% sy, 0.0% ni, 99.3% id, 0.0% wa, 0.0% hi, 0.0%
si
>Mem: 2074668k total, 368216k used, 1706452k free, 33332k
buffers
>Swap: 2096472k total, 0k used, 2096472k free, 110968k cached
>
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 7908 unitel 16 0 1474m 179m 8724 S 0.7 8.8 0:02.75 java
> 1 root 16 0 2788 544 464 S 0.0 0.0 0:00.83 init
>
>
>À§ÀÇ ³»¿ëÀ» º¸¸é ½ÇÁ¦ cpu¹× ¸Þ¸ð¸® ±×¸®°í AP¼¹öÀÇ ÇÁ·Î±×·¥ java º¸¸é °ÅÀÇ
¼¹öÀÚüÀÇ ºÎÇÏ´Â ¾ø´Â°ÍÀ¸·Î º¸ÀÔ´Ï´Ù.
>AP ¼¹ö 2´ëÀüºÎ À§ÀÇ »óȲó·³ ¼¹öÀÚü ºÎÇÏ´Â °ÅÀÇ º¸ÀÌÁö ¾Ê´Â
»óȲÀÔ´Ï´Ù.
>
>load average ¹× free Á¤º¸¸¦ ºÁµµ ¾ÆÁÖ Á¶¿ëÇÑ ÇüÅÂÀÔ´Ï´Ù.
>[uel@log ~]$ uptime
> 20:42:53 up 4:03, 3 users, load average: 0.08, 0.05, 0.04
>[uel@log ~]$ free
> total used free shared buffers
cached
>Mem: 2074668 375752 1698916 0 33464
113436
>-/+ buffers/cache: 228852 1845816
>Swap: 2096472 0 2096472
>
>
>
>±×·±µ¥ netstat¸¦ º¸¸é
>¾Æ·¡´Â 20010Á¢¼Ó¿¡ ´ëÇÑ netstat³»¿ëÀÇ ÀϺκРÀÔ´Ï´Ù.
>[uel@log ]# netstat -na | grep :20010
>tcp 0 0 192.168.100.201:20010 122.29.249.88:61778
SYN_RECV
>tcp 0 0 192.168.100.201:20010 220.106.108.46:2136
SYN_RECV
>tcp 0 0 192.168.100.201:20010 211.17.38.85:2271
SYN_RECV
>tcp 0 0 192.168.100.201:20010 210.249.36.48:1580
SYN_RECV
>tcp 0 0 192.168.100.201:20010 59.139.22.193:63843
SYN_RECV
>tcp 0 0 192.168.100.201:20010 60.45.74.211:62265
SYN_RECV
>tcp 0 0 192.168.100.201:20010 61.214.132.156:1354
SYN_RECV
>tcp 0 0 192.168.100.201:20010 221.249.48.138:1297
SYN_RECV
>tcp 0 0 192.168.100.201:20010 60.236.29.40:10148
SYN_RECV
>tcp 0 0 192.168.100.201:20010 210.150.101.205:60368
SYN_RECV
>tcp 0 0 192.168.100.201:20010 211.129.222.171:1564
SYN_RECV
>tcp 0 0 192.168.100.201:20010 210.249.97.144:8527
SYN_RECV
>tcp 0 0 192.168.100.201:20010 221.252.164.226:1832
SYN_RECV
>tcp 0 0 192.168.100.201:20010 61.204.195.134:1408
SYN_RECV
>tcp 0 0 192.168.100.201:20010 222.149.211.36:18208
SYN_RECV
>tcp 0 0 :::20010 :::*
LISTEN
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:203.179.90.241:33859
ESTABLISHED
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:210.249.97.144:1105
ESTABLISHED
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:58.81.55.226:12287
ESTABLISHED
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:221.244.199.162:2795
ESTABLISHED
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:59.139.22.193:61474
ESTABLISHED
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:59.139.22.209:44850
ESTABLISHED
>
>----------------------- »ý·« ------------------------------
>
> 20010 Æ÷Æ® ÀÇ ¾×¼½½º ¼ö´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
>[uel@log ]# netstat -na |grep :20010 | wc -l
>80
>
>20010ÀÇ ESTABLISHED ¼öÀÔ´Ï´Ù.
>[uel@log]# netstat -na |grep :20010 | grep ESTABL | wc -l
>61
>
>[uel@log]# netstat -na |grep :20010 | grep SYN_RECV | wc -l
>20
>
>À§¿Í °°ÀÌ AP¼¹ö 2´ë°¡ °ÅÀÇ °°Àº SYN_RECV°¡ 20 ÀÌ»ó °è¼Ó ¹ß»ýÇÏ°í
ÀÖ½À´Ï´Ù.
>Á¦°¡ ¾Ë°í ÀÖ´Â syn_recv´Â Ŭ¶óÀ̾ðÆ®¿¡¼ synÀ» ¹Þ°í ³ª¼ ¼¹ö°¡ syn+ack¸¦
Ŭ¶óÀ̾ðÆ®¿¡ µÇµ¹·Á ÁØÈÄ¿¡ Ŭ¶óÀ̾ðÆ®¿¡¼ ack°¡ ¿Ã°ÍÀ̶ó´Â °ÍÀ» ±â´Ù¸®´Â half
open»óÅ·Π¾Ë°í ÀÖ½À´Ï´Ù.
>
>ÀÌ·± syn_recv°¡ ¸¹ÀÌ ¹ß»ýÇѴٴ°ÍÀº ¼ºñ½º°ÅºÎ°ø°Ý ÇüÅ°¡ ÀÖ´Ù°í ¾Ë°íÀÖ½À´Ï´Ù.
ÇÏÁö¸¸ ÇöÀç ap¼¹ö¿¡ ¹ß»ýÇÏ´Â syn_recvÀÇ Å¬¶óÀ̾ðÆ® ip´Â ½ÇÁ¦ Á¤»óÀûÀΠŬ¶óÀ̾ðÆ®
¾ÆÀÌÇÇ ÀÔ´Ï´Ù.. ÀÌ·²°æ¿ì syn_recv°¡ ¹ß»ýÇÏ´Â ¿øÀÎÀÌ ¹«¾ùÀÎÁö¿ä?
>
>Ŭ¶óÀ̾ðÆ®¿¡¼ ACK°¡ ¿ÀÁö ¾Ê´Â ÀÌÀ¯¸¦ ¸ð¸£°Ú½À´Ï´Ù. .Ŭ¶óÀ̾ðÆ® ¹®Á¦·Î º¸ÀÌÁö´Â
¾Ê´Âµ¥¿ä..
>
>
>Áß°£¿¡ ÀÖ´Â ·Îµå¹ë··½ÌÀÌ Á¦´ë·Î 󸮸¦ ¸øÇϴ°ÍÀÌ ¹®Á¦ÀÎÁö. ½Ã¿øÇÑ ´äÀÌ
¾È³ª¿É´Ï´Ù.. ·Îµå¹ë··½Ì ¿¡¼ º¸¸é
>¹Ý¾¿ Ä¿³Ø¼Ç¼ö¸¦ ³ª´©¾î AP¼¹ö 2´ë¿¡ ³ª´©¾î ÁÖ°í ÀÖ½À´Ï´Ù¸¸. ¿ÜºÎ¿¡¼ 20010 Æ÷Æ®¿¡
´ëÇÑ Ä¿³Ø¼Ç¼ö°¡ µ¿½ÃÁ¢¼Ó¼ö°¡ ÇÕ°èÄ¡°¡ 200 Á¤µµÀÇ ÀÌ»óÀÇ
>¼öÄ¡°¡ ³ª¿À±âµµ ÇÕ´Ï´Ù. ½ÇÁ¦ AP¼¹ö 2´ëÀÇ 20010Æ÷Æ® Á¢¼Ó¼ö¸¦ ºñ±³Çغ¸¸é 200Ä¿³Ø¼Ç
¼ö°¡ ³ª¿ÀÁö ¾Ê°í Àִµ¥¿ä.. ·Îµå¹ë··½ÌÀÌ ÀÌ»óÇѰ͵µ °°±âµµ , Æò¼Ò¶§´Â º¸Åë ÇÕÃļ
40Ä¿³Ø¼Ç Á¤µµÀÔ´Ï´Ù¸¸.. À̹øÁÖ ºÎÅÍ ÀÌÇØÇϼö¾ø´Â ¼öÄ¡ÀÇ Ä¿³Ø¼Ç¼ö°¡ ¹ß»ýÇÏ°í
ÀÖ½À´Ï´Ù.
>
>ÇÏÁö¸¸ ±×¿Ü 80,443 ¼ºñ½º °æ¿ì¿¡´Â ºÎÇÏºÎ»ê ¼öÄ¡¸¦ ºñ±³Çغ¸¸é Á¦´ë·Î web¼¹ö¿ÍÀÇ
Ä¿³Ø¼Ç¼ö¿Í ÀÏÄ¡Çϴ°ÍÀ» º¸¸é, 20010Æ÷Æ®¿¡ °üÇÑ ½ÇÁ¦ Á¢¼Ó·®ÀÌ ¸¹Àº°ÍÀÎÁö
Àǽɽº·´±âµµ ÇÕ´Ï´Ù.
>
>µ¥ÀÌŸ¼¾ÅÍ¿¡¼ Á¦°øÇØÁִ ȸ¼± Æ®·¢ÇÈ MRTG¸¦ º¸¸é Æ®·¢ÇÈÀÌ ±Þ°ÝÇÏ°Ô ¹ß»ýÇÏÁö´Â
¾Ê¾Ò½À´Ï´Ù..Á¶±Ý Áõ°£ ÇÑ°ÍÀ» º¼¼öÀÖÁö¸¸. ÇÑ´ÞÀü°ú ºñ±³ÇØ 2¹è ÀÌ»ó ´Ã¾î³ªÁöµµ ¾ÊÀº
»óȲÀÔ´Ï´Ù...
>
>
>ÇöÀç ¿ÜºÎ¿¡¼ °¨½Ã¼¹ö¸¦ ÅëÇØ 20010¸¦ °¨½ÃÇÏ°í ÀÖ½À´Ï´Ù.¸¸ °æ°í¸ÞÀÏÀÌ 1ºÐ °£°ÝÀ¸·Î
20010Æ÷Æ®°¡ Á¢¼ÓÀÌ µÇ´Ù°¡ ¾ÈµÇ´Ù°¡¸¦ ¹Ýº¹ÇÏ°í ÀÖ½À´Ï´Ù..
>½ÇÁ¦ AP¼¹ö·Î Á¢¼ÓÇؼ telnet localhost 20010 ÇüÅ·Πlocal¿¡¼ È®ÀÎÇغ¸¸é Ä¿³Ø¼ÇÀÌ
Á¢¼ÓµÇÁö ¾Ê´Ù°¡ 50ÃÊ ÈÄ¿¡ °æ¿ì Á¢¼Ó µÉ Á¤µµÀÔ´Ï´Ù.
>
>Syn_recvÀ̶û Á¢¼Ó¼öÀÇ »ó°ü°ü°è°¡ ÀÖ´ÂÁö¿ä? Á¢¼Ó·®ÀÌ ¸¹À»°æ¿ì¿¡ syn_recv°¡
¹ß»ýÇϴ°ÍÀÌ ÀÚ¿¬½º·´¿î Çö»óÀÎÁö ±Ã±ÝÇÕ´Ï´Ù..
>
>
>tcpdump¸¦ °¢ ap ¼¹ö¿Í ·Îµå¹ë··½Ì ¾Õ´Ü¿¡¼ ¶°¼ Áö±Ý ºÐ¼®ÁßÀÔ´Ï´Ù¸¸..
>
>¸¶Áö¸·À¸·Î netstat °á°ú¸¦ º¸¸é ¾Æ·¡¿Í °°ÀÌ ESTABLISHED ÇüÅ·ΠÁ¦´ë·Î Á¢¼ÓµÇ
°æ¿ì¿¡µµ Recv-Q¸¦ º¸¸é ¾ÆÁ÷ ó¸®ÇÏÁö ¸øÇÑ ¹ÙÀÌÆ®¼ö°¡ ÀÖ´Â
>ESTABLISHED °¡ ¾öû ¸¹ÀÌ Á¸ÀçÇÏ°í ÀÖ½À´Ï´Ù.
>À̰͵µ ¹®Á¦ÀÎ°Í °°½À´Ï´Ù. Á¦ ÃßÃøÀÔ´Ï´Ù¸¸ ³Ñ°ÜÁÖÁö ¸øÇÑ ÆÐŶÀÌ ¸¹´Ù´Â°ÍÀº AP¼¹ö°¡
Ŭ¶óÀ̾ðÆ®¿¡¼ ¹Þ¾ÆµéÀÎ ÆÐŶÀ» DB¼¹ö¿¡ Á¦´ë·Î ³Ñ°ÜÁÖÁö ¸øÇؼ ÀΰÍ
°°Àºµ¥¿ä..
>
>--------------------------------------------------------------------
>[uel@log AP1]# netstat -ntp
>Active Internet connections (w/o servers)
>Proto Recv-Q Send-Q Local Address Foreign Address State
PID/Program name
>
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:210.233.5.10:1250
ESTABLISHED -
>tcp 81 0 ::ffff:192.168.100.20:20010 ::ffff:61.205.238.83:1392
ESTABLISHED 19123/java
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:221.244.61.82:2199
ESTABLISHED -
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:221.244.199.162:1377
ESTABLISHED -
>tcp 51 0 ::ffff:192.168.100.20:20010 ::ffff:61.118.149.124:44257
ESTABLISHED -
>:122.213.62.18:23368 ESTABLISHED -
>---------------------------------------------------------------------
>
>
>Ãß°¡ÀûÀ¸·Î DB¼¹öÀÇ top Á¤º¸ÀÔ´Ï´Ù.
>Áö±Ý È®ÀÎ Çغ¸´Ï mysql µ¥¸óÀÇ cpuÁ¡À¯À²ÀÌ ¾öû ¸¹¾Æ º¸ÀÔ´Ï´Ù.
>loadµµ ²Ï ¸¹ÀÌ ³ô°í¿ä
>`-----------------------------------------------------
>top - 21:57:21 up 566 days, 6:44, 4 users, load average: 1.59, 1.52,
1.46
>Tasks: 110 total, 4 running, 106 sleeping, 0 stopped, 0 zombie
>Cpu0 : 34.6% us, 1.0% sy, 0.0% ni, 57.5% id, 7.0% wa, 0.0% hi, 0.0%
si
>Cpu1 : 96.0% us, 1.7% sy, 0.0% ni, 2.3% id, 0.0% wa, 0.0% hi, 0.0%
si
>Cpu2 : 0.3% us, 0.3% sy, 0.0% ni, 99.3% id, 0.0% wa, 0.0% hi, 0.0%
si
>Cpu3 : 85.4% us, 4.0% sy, 0.0% ni, 10.6% id, 0.0% wa, 0.0% hi, 0.0%
si
>Mem: 4086200k total, 4064732k used, 21468k free, 49584k
buffers
>Swap: 2096472k total, 13196k used, 2083276k free, 3467856k cached
>
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 5429 mysql 17 0 443m 399m 3344 R 99.8 10.0 1393:28 mysqld
>22512 mysql 17 0 443m 399m 3344 R 73.5 10.0 54:15.82 mysqld
>22491 mysql 16 0 443m 399m 3344 R 49.6 10.0 46:00.56 mysqld
>23999 unitel 16 0 3220 960 752 R 0.7 0.0 0:00.04 top
>30390 root 15 0 22396 10m 2268 S 0.3 0.3 24:21.17 X
>-----------------------------------------------------------------
>
>
>
>DB¼¹öÀÇ mysqlÀÇ Á¤º¸ÀÔ´Ï´Ù.
>
>Queries per second avg: 79.808 ÀÌ ³»¿ë ºÎºÐÀÌ Á» °É¸®³×¿ä
>
>------------------------------------------------------------
>Connection Localhost via UNIX socket
>UNIX socket /tmp/mysql.sock
>Uptime: 294 days 11 hours 25 min 15 sec
>
>Threads: 12 Questions: 2030538121 Slow queries: 0 Opens: 0 Flush tables: 32
Open tables: 178 Queries per second avg: 79.808
>-------------------------------------------------------------
>
>
>mysqlÀÇ extended-status Á¤º¸ÀÔ´Ï´Ù.
>+-----------------------------------+--------------+
>| Variable_name | Value |
>+-----------------------------------+--------------+
>| Aborted_clients | 14831 |
>| Aborted_connects | 53976 |
>| Binlog_cache_disk_use | 0 |
>| Binlog_cache_use | 0 |
>| Bytes_received | 4183154635 |
>| Bytes_sent | 4182490453 |
>| Com_admin_commands | 907105 |
>| Com_alter_db | 0 |
>| Com_alter_table | 25 |
>| Com_analyze | 3 |
>| Com_backup_table | 0 |
>| Com_begin | 0 |
>| Com_change_db | 766 |
>| Com_change_master | 0 |
>| Com_check | 9 |
>| Com_checksum | 0 |
>| Com_commit | 19 |
>| Com_create_db | 0 |
>| Com_create_function | 0 |
>| Com_create_index | 0 |
>| Com_create_table | 20217 |
>| Com_dealloc_sql | 0 |
>| Com_delete | 9457511 |
>| Com_delete_multi | 3 |
>| Com_do | 0 |
>| Com_drop_db | 0 |
>| Com_drop_function | 0 |
>| Com_drop_index | 0 |
>| Com_drop_table | 20218 |
>| Com_drop_user | 0 |
>| Com_execute_sql | 0 |
>| Com_flush | 31 |
>| Com_grant | 0 |
>| Com_ha_close | 0 |
>| Com_ha_open | 0 |
>| Com_ha_read | 0 |
>| Com_help | 0 |
>| Com_insert | 172890149 |
>| Com_insert_select | 857 |
>| Com_kill | 256 |
>| Com_load | 0 |
>| Com_load_master_data | 0 |
>| Com_load_master_table | 0 |
>| Com_lock_tables | 588 |
>| Com_optimize | 0 |
>| Com_preload_keys | 0 |
>| Com_prepare_sql | 0 |
>| Com_purge | 0 |
>| Com_purge_before_date | 0 |
>| Com_rename_table | 0 |
>| Com_repair | 8 |
>| Com_replace | 33657448 |
>| Com_replace_select | 42232 |
>| Com_reset | 0 |
>| Com_restore_table | 0 |
>| Com_revoke | 0 |
>| Com_revoke_all | 0 |
>| Com_rollback | 5 |
>| Com_savepoint | 0 |
>| Com_select | 198983161 |
>| Com_set_option | 36763 |
>| Com_show_binlog_events | 0 |
>| Com_show_binlogs | 0 |
>| Com_show_charsets | 0 |
>| Com_show_collations | 9019 |
>| Com_show_column_types | 0 |
>| Com_show_create_db | 0 |
>| Com_show_create_table | 5993 |
>| Com_show_databases | 148 |
>| Com_show_errors | 0 |
>| Com_show_fields | 6072 |
>| Com_show_grants | 0 |
>| Com_show_innodb_status | 0 |
>| Com_show_keys | 66 |
>| Com_show_logs | 0 |
>| Com_show_master_status | 5 |
>| Com_show_ndb_status | 0 |
>| Com_show_new_master | 0 |
>| Com_show_open_tables | 0 |
>| Com_show_privileges | 0 |
>| Com_show_processlist | 151637 |
>| Com_show_slave_hosts | 669 |
>| Com_show_slave_status | 1 |
>| Com_show_status | 7 |
>| Com_show_storage_engines | 0 |
>| Com_show_tables | 3381 |
>| Com_show_triggers | 5577 |
>| Com_show_variables | 9708 |
>| Com_show_warnings | 1 |
>| Com_slave_start | 0 |
>| Com_slave_stop | 0 |
>| Com_stmt_close | 40090696 |
>| Com_stmt_execute | 40107513 |
>| Com_stmt_fetch | 0 |
>| Com_stmt_prepare | 40099462 |
>| Com_stmt_reset | 0 |
>| Com_stmt_send_long_data | 0 |
>| Com_truncate | 0 |
>| Com_unlock_tables | 588 |
>| Com_update | 63499290 |
>| Com_update_multi | 5 |
>| Com_xa_commit | 0 |
>| Com_xa_end | 0 |
>| Com_xa_prepare | 0 |
>| Com_xa_recover | 0 |
>| Com_xa_rollback | 0 |
>| Com_xa_start | 0 |
>| Compression | OFF |
>| Connections | 65922 |
>| Created_tmp_disk_tables | 12041 |
>| Created_tmp_files | 147 |
>| Created_tmp_tables | 421243412 |
>| Delayed_errors | 0 |
>| Delayed_insert_threads | 0 |
>| Delayed_writes | 0 |
>| Flush_commands | 32 |
>| Handler_commit | 0 |
>| Handler_delete | 5131664 |
>| Handler_discover | 0 |
>| Handler_prepare | 0 |
>| Handler_read_first | 215559225 |
>| Handler_read_key | 110530486 |
>| Handler_read_next | 2452367653 |
>| Handler_read_prev | 0 |
>| Handler_read_rnd | 60148746 |
>| Handler_read_rnd_next | 3953640529 |
>| Handler_rollback | 0 |
>| Handler_savepoint | 0 |
>| Handler_savepoint_rollback | 0 |
>| Handler_update | 2052955131 |
>| Handler_write | 681769258 |
>| Innodb_buffer_pool_pages_data | 19 |
>| Innodb_buffer_pool_pages_dirty | 0 |
>| Innodb_buffer_pool_pages_flushed | 0 |
>| Innodb_buffer_pool_pages_free | 493 |
>| Innodb_buffer_pool_pages_latched | 0 |
>| Innodb_buffer_pool_pages_misc | 0 |
>| Innodb_buffer_pool_pages_total | 512 |
>| Innodb_buffer_pool_read_ahead_rnd | 1 |
>| Innodb_buffer_pool_read_ahead_seq | 0 |
>| Innodb_buffer_pool_read_requests | 77 |
>| Innodb_buffer_pool_reads | 12 |
>| Innodb_buffer_pool_wait_free | 0 |
>| Innodb_buffer_pool_write_requests | 0 |
>| Innodb_data_fsyncs | 3 |
>| Innodb_data_pending_fsyncs | 0 |
>| Innodb_data_pending_reads | 0 |
>| Innodb_data_pending_writes | 0 |
>| Innodb_data_read | 2494464 |
>| Innodb_data_reads | 25 |
>| Innodb_data_writes | 3 |
>| Innodb_data_written | 1536 |
>| Innodb_dblwr_pages_written | 0 |
>| Innodb_dblwr_writes | 0 |
>| Innodb_log_waits | 0 |
>| Innodb_log_write_requests | 0 |
>| Innodb_log_writes | 1 |
>| Innodb_os_log_fsyncs | 3 |
>| Innodb_os_log_pending_fsyncs | 0 |
>| Innodb_os_log_pending_writes | 0 |
>| Innodb_os_log_written | 512 |
>| Innodb_page_size | 16384 |
>| Innodb_pages_created | 0 |
>| Innodb_pages_read | 19 |
>| Innodb_pages_written | 0 |
>| Innodb_row_lock_current_waits | 0 |
>| Innodb_row_lock_time | 0 |
>| Innodb_row_lock_time_avg | 0 |
>| Innodb_row_lock_time_max | 0 |
>| Innodb_row_lock_waits | 0 |
>| Innodb_rows_deleted | 0 |
>| Innodb_rows_inserted | 0 |
>| Innodb_rows_read | 0 |
>| Innodb_rows_updated | 0 |
>| Key_blocks_not_flushed | 0 |
>| Key_blocks_unused | 0 |
>| Key_blocks_used | 334283 |
>| Key_read_requests | 213404926012 |
>| Key_reads | 4472707 |
>| Key_write_requests | 221195201 |
>| Key_writes | 109920190 |
>| Last_query_cost | 0.000000 |
>| Max_used_connections | 60 |
>| Not_flushed_delayed_rows | 0 |
>| Open_files | 236 |
>| Open_streams | 0 |
>| Open_tables | 178 |
>| Opened_tables | 41811 |
>| Qcache_free_blocks | 39 |
>| Qcache_free_memory | 16036752 |
>| Qcache_hits | 2628065 |
>| Qcache_inserts | 4028217 |
>| Qcache_lowmem_prunes | 0 |
>| Qcache_not_cached | 194965259 |
>| Qcache_queries_in_cache | 249 |
>| Qcache_total_blocks | 551 |
>| Questions | 2030539894 |
>| Rpl_status | NULL |
>| Select_full_join | 879262 |
>| Select_full_range_join | 379 |
>| Select_range | 11324395 |
>| Select_range_check | 2 |
>| Select_scan | 131812967 |
>| Slave_open_temp_tables | 0 |
>| Slave_retried_transactions | 0 |
>| Slave_running | OFF |
>| Slow_launch_threads | 0 |
>| Slow_queries | 1440 |
>| Sort_merge_passes | 351 |
>| Sort_range | 473 |
>| Sort_rows | 91476889 |
>| Sort_scan | 107289 |
>| Ssl_accept_renegotiates | 0 |
>| Ssl_accepts | 0 |
>| Ssl_callback_cache_hits | 0 |
>| Ssl_cipher | |
>| Ssl_cipher_list | |
>| Ssl_client_connects | 0 |
>| Ssl_connect_renegotiates | 0 |
>| Ssl_ctx_verify_depth | 0 |
>| Ssl_ctx_verify_mode | 0 |
>| Ssl_default_timeout | 0 |
>| Ssl_finished_accepts | 0 |
>| Ssl_finished_connects | 0 |
>| Ssl_session_cache_hits | 0 |
>| Ssl_session_cache_misses | 0 |
>| Ssl_session_cache_mode | NONE |
>| Ssl_session_cache_overflows | 0 |
>| Ssl_session_cache_size | 0 |
>| Ssl_session_cache_timeouts | 0 |
>| Ssl_sessions_reused | 0 |
>| Ssl_used_session_cache_entries | 0 |
>| Ssl_verify_depth | 0 |
>| Ssl_verify_mode | 0 |
>| Ssl_version | |
>| Table_locks_immediate | 1179431231 |
>| Table_locks_waited | 9485969 |
>| Tc_log_max_pages_used | 0 |
>| Tc_log_page_size | 0 |
>| Tc_log_page_waits | 0 |
>| Threads_cached | 3 |
>| Threads_connected | 12 |
>| Threads_created | 855 |
>| Threads_running | 5 |
>| Uptime | 25442788 |
>+-----------------------------------+--------------+
>
>
>¿©±âÀú±â º¸°í ÇغÁµµ Àú È¥ÀÚ¼ ÇØ°áÀÌ Á» ¾î·Á¿òÀÌ ¸¹´Ùº¸´Ï. »êÀÌ´Ô²² ÀÛÀº
Á¶¾ðÀÌ¶óµµ ÇØÁֽñ⠹ٶø´Ï´Ù..
>
>±ä ³»¿ë Àоî Áּż °¨»çÇÕ´Ï´Ù..
========================================
DB ¼¹ö, AP ¼¹ö ¸ðµÎ ÀÌ»óÀÌ ¾ø´Â°Í °°½À´Ï´Ù. ¿ÜºÎÀÇ °ø°ÝÀ̶ó°í ´ÜÁ¤ÁöÀ»¸¸ÇÑ ´Ü¼´Â
¾ø±¸¿ä.
¹®Á¦´Â AP ¼¹öÀÇ TCP 20010 Æ÷Æ®¸¦ »ç¿ëÇÏ´Â ¾îÇø®ÄÉÀÌ¼Ç ¹®Á¦ÀÎ°Í °°½À´Ï´Ù. Áï ÀÌ
¾îÇø®ÄÉÀ̼ÇÀÌ ´ë¿ë·® Ä¿³Ø¼Ç 󸮸¦ Àç´ë·Î ¸øÇÏ°í ÀÖ´Â°Í °°½À´Ï´Ù.
AP ¼¹ö¿¡ ssh Á¢¼ÓÇؼ telnet À¸·Î ´Ù¸¥ Æ÷Æ®·Î Á¢¼Ó(¿¬°á) Å×½ºÆ®Çغ¸¼¼¿ä.
¸¸¾à ´Ù¸¥ Æ÷Æ®¿¡ delay ¾øÀÌ °ð¹Ù·Î ¿¬°áµÇ¸é 20010 Æ÷Æ®¸¦ »ç¿ëÇÏ´Â ¾îÇø®ÄÉÀ̼Ç
¹®Á¦°¡ È®½ÇÇÕ´Ï´Ù. <-- ÀÌ°Ô È®½ÇÇÏ´Ù¸é °³¹ßÀÚ¿¡°Ô ¼öÁ¤¿äûÇϼ¼¿ä.
±×¿Ü¿¡ Ŭ¶óÀ̾ðÆ® Á¡Æ÷°¡ Á¤ÇØÁø IP ÁÖ¼Ò¶ó¸é ÀÌ IP ÁÖ¼Ò¿Ü¿¡ ¸ðµÎ iptables ·Î ¸·´Â°ÍÀÌ
ÁÁ½À´Ï´Ù.
|