¾ðÁ¦³ª ¼ÒÁßÇÑ ´äº¯ °¨»çÇÕ´Ï´Ù.
°³¹ßÀÚ¿¡°Ô ÀÏ´Ü À̾߱â Çؼ ÇÁ·Î±×·¥ÂÊÀ¸·Î
È®ÀÎÁß¿¡ ÀÖ½À´Ï´Ù.
°³ÀÎÀûÀ¸·Î ½Ç·ÂÀÌ µþ·Á¼ ±×·±Áö.. ³í¸®ÀûÀ¸·Î °³¹ßÀÚ¿¡°Ô ³³µæ½ÃÅ°´Â Á¡ÀÌ ¾î·Æ³×¿ä..
°¨»çÇÕ´Ï´Ù..ÁÁÀº ÇÏ·çµÇ¼¼¿ä...
[»êÀÌ]´ÔÀÌ ³²±â½Å ±Û:
>
>[ÀÌÇöö]´ÔÀÌ ³²±â½Å ±Û:
>
>>-----------------------------------------
>>´äº¯ÀÚ°¡ ±âº»ÀûÀ¸·Î Âü°íÇÒ ³»¿ëÀÔ´Ï´Ù.
>>- ¹èÆ÷ÆÇ(¿É¼Ç) :
>>- Ä¿³Î¹öÀü(¿É¼Ç) :
>>- µ¥¸ó¹öÀü(¿¹: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 ·Î
¸·´Â°ÍÀÌ ÁÁ½À´Ï´Ù.
========================================
|