-----------------------------------------
´äº¯ÀÚ°¡ ±âº»ÀûÀ¸·Î Âü°íÇÒ ³»¿ëÀÔ´Ï´Ù.
- ¹èÆ÷ÆÇ(¿É¼Ç) :
- Ä¿³Î¹öÀü(¿É¼Ç) :
- µ¥¸ó¹öÀü(¿¹: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 |
+-----------------------------------+--------------+
¿©±âÀú±â º¸°í ÇغÁµµ Àú È¥ÀÚ¼ ÇØ°áÀÌ Á» ¾î·Á¿òÀÌ ¸¹´Ùº¸´Ï. »êÀÌ´Ô²² ÀÛÀº Á¶¾ðÀ̶óµµ
ÇØÁֽñ⠹ٶø´Ï´Ù..
±ä ³»¿ë Àоî Áּż °¨»çÇÕ´Ï´Ù..
|