• ÇÁ¸®Ä«¿îÅÍ
  • Ç÷¡½ÃºÏ
  • ÇÁ¸®º¸µå
  • Àü±¤ÆÇ
  • À¥°øºÎ¹æ
  • Ä¿¹Â´ÏƼ
[mysql] skip-name-resolve 2011.11.18 16:39
±Û¾´ÀÌ : ¿î¿µÀÚ Á¶È¸ : 122 Ãßõ : 0
 

skip-name-resolve´Â client ¿¡¼­ server·Î Á¢¼Ó½Ã¿¡ DNS Lookup °úÁ¤À» »ý·«ÇØ ÁÝ´Ï´Ù. localhost ·Î Á¢¼ÓÇÏ´Â °æ¿ì´Â ¹®Á¦°¡ ¾øÁö¸¸ IP ·Î Á¢¼ÓÇϴ ȯ°æ¿¡¼­´Â DNS ¼­¹ö°¡ ´À¸®°Å³ª ¾Æ´Ô Àå¾Ö ¹ß»ý½Ã¿¡ ÇØ´ç ¿É¼ÇÀ» ¼³Á¤ÇØ ÁֹǷνá DB Á¢¼Ó½Ã¿¡ ¹®Á¦Á¡À» ÇØ°áÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.

[root@smson root]# vi /etc/my.cnf

# The MySQL server
[mysqld]
skip-external-locking
skip-host-cache
skip-locking
skip-name-resolve
back_log = 768
basedir = /opt/mysql/
connect_timeout = 30

ÀλýÀº ª½À´Ï´Ù.
±×·¯¹Ç·Î ´Ù¸¥ »ç¶÷ÀÌ ¿ä±¸ÇÏ´Â »îÀ» »ì¸é¼­ ½Ã°£À» ³¶ºñÇؼ­´Â ¾È µË´Ï´Ù.
µ·°ú ¸í¿¹¸¦ ¾òÁö ¸øÇÏ´õ¶óµµ ³¡±îÁö ÀÚ½ÅÀÇ ±æÀ» °íÁýÇϽʽÿÀ
¸ñ·Ï À­±Û ¾Æ·§±Û
³»¾Ë FREECOUNT.NET ÇÁÄ«³Ý »ý±ä³¯ 2003.12.20 Ȩ | Ä«¿îÅÍ | Ç÷¡½ÃºÏ | ÇÁ¸®º¸µå | Àü±¤ÆÇ | À¥°øºÎ¹æ | Ä¿¹Â´ÏƼ | ÂÊÁöÇÔ