Q&A
- Mysql/Oracle/Query/DB Áú¹®°ú´äº¯
'Å¥ °ø°£ ¶Ç´Â ¹öÆÛ°¡ ºÎÁ·ÇÏ¿© ¼ÒÄÏ¿¡¼ ÇØ´ç ÀÛ¾÷À» ÁøÇàÇÏÁö ¸øÇß½À´Ï´Ù.'¶ó´Â ¿¡·¯°¡ ÀÚÁÖ ³³´Ï´Ù. | |||||
±Û¾´ÀÌ | Á¤»ó¼ö | ³¯ Â¥ | 10-04-03 14:59 | Á¶ ȸ | 15309 |
---|---|---|---|---|---|
°£ÆíURL |
https://www.phpschool.com/link/qna_db/162243
|
||||
À©µµ¿ìÁî 2003¿¡¼ APMSetup7 À» »ç¿ëÁßÀÔ´Ï´Ù.
Ãֱ٠ȨÆäÀÌÁö ¹æ¹®ÀÚ°¡ ´Ã¾î³ª´Ï ¾ÆÆÄÄ¡ error.log ¿¡ [Sat Apr 03 14:14:41 2010] [error] [client xxx.xxx.xxx.xxx] PHP Warning: mysql_connect(): Å¥ °ø°£ ¶Ç´Â ¹öÆÛ°¡ ºÎÁ·ÇÏ¿© ¼ÒÄÏ¿¡¼ ÇØ´ç ÀÛ¾÷À» ÁøÇàÇÏÁö ¸øÇß½À´Ï´Ù. ¶ó´Â ¿¡·¯°¡ ¼ø½Ä°£¿¡ ¸îGB »ý¼ºµÇ¸é¼ ¼¹ö°¡ Á×¾î¹ö¸®´Â °æ¿ì°¡ ÀÚÁÖ ÀϾ´Ï´Ù. ¼ºñ½º¿¡¼ APM_APACHE2 ¸¦ Àç½ÃÀÛÇÏ¸é »çÀÌÆ®°¡ Àß ¶ß±äÇϴµ¥ ÇÏ·ç¿¡µµ ¸î¹ø¾¿ ȨÆäÀÌÁö°¡ Á׾® ºÒ¾ÈÇϳ׿ä. ÀÌ °æ¿ì ¾î¶² ºÎºÐÀ» ¼öÁ¤ÇؾߵÉÁö ¾Æ½Ã´Â ºÐ ¾øÀ»±î¿ä? ȯ°æ¼³Á¤ÆÄÀÏÀ̶ó´øÁö... ¼¹ö¼³Á¤À̶óµçÁö ±âŸ µîµî µµ¿ò µÉ¸¸ÇÑ ¾î¶² ³»¿ëÀÌ¶óµµ ¾Ë·ÁÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.
|
Àüü´ñ±Û¼ö 7
-
´©³ª¼Ò±Ý 10-04-03 17:06
¼Ò½ºº¸±â
-
¸Þ¸ð¸®~°¡ 4G Á¤µµ µÇ½Ã³ª¿ä?
¹öÆÛ¸¦ »ì¦ ¿Ã·Á º¸¼¼¿ä. ¸¹ÀÌ ¿Ã¸°´Ù°í Çؼ ÁÁÀº °Ô ¾Æ´Ï¶ó¼¿ä.
¼¹ö¸¶´Ù Àû´çÇÑ ¼º´É~ÀÌ ÀÖ½À´Ï´Ù.
[mysqld] ¾Æ·¡ ÂÊ¿¡¼ 5°³ÀÇ °ªÀ» ¿Ã¸®½Ã°í, ±× ¾Æ·¡ 5 °³´Â Ãß°¡È÷½Å ÈÄ,
mysql À» STOP START ÇØ º¸¼¼¿ä.
C:\APM_Setup\Server\MySQL5\data\my.ini
[mysqld]
key_buffer_size = 16M => 384
sort_buffer_size = 512K => 2M
read_buffer_size = 256K => 2M
read_rnd_buffer_size = 512K => 8M
myisam_sort_buffer_size = 8M => 64M
thread_cache_size = 8
query_cache_size = 32M
net_buffer_length = 8K
table_cache = 512
table_open_cache = 64
==========
http://fr33cat.com/100046137543
10055 ´ë±â¿ÀÌ ¶Ç´Â ¹öÆÛ°¡ ºÎÁ·ÇÏ¿© ¼ÒÄÏ¿¡¼ ÇØ´ç ÀÛ¾÷À» ÁøÇàÇÏÁö ¸øÇß½À´Ï´Ù
¾Æ·¡ ¹®¼ º¸½Ã°í, ¾ó¸¶³ª ¸¹Àº Á¢¼Ó~ÀÌ ÀÌ·ç¾îÁö´Â Áö È®ÀÎÇϼ¼¿ä.
http://urin79.com/321499
C:\>netstat -an
mysql> show processlists;
slow-query µµ üũÇØ º¸½Ã°í,
ÀüüÀûÀ¸·Î ¼¹ö ¼º´É~ üũ~ ¹× ÃÖÀûÈ~µµ ÇØ¾ß ÇÕ´Ï´Ù.
½½·Î¿ì Äõ¸®~°¡ ¸¹ÀÌ »ý±â¸é, ¼¹ö~¿¡ Á¡Á¡ ¹®Á¦°¡ »ý±â´Ù°¡ ´Ù¿îÀÌ µÇ±â ½ÃÀÛÇÕ´Ï´Ù.
OS ¸¶´Ù ÃÖ´ë·Î »ý¼ºÇÒ ¼ö ÀÖ´Â ¼ÒÄÏ~ÀÇ ¼ö´Â Á¦ÇÑÀÌ µÇ¾î ÀÖ½À´Ï´Ù.
php ÀÇ slow-query ¿Í, ±âŸ Äõ¸®~µéÀ» ã¾Æ³»¼, ÃÖÀûÈ~½ÃÄÑ¾ß ÇÕ´Ï´Ù.
'ÀÏ¹Ý º¸µå'¸¦ »ç¿ëÇÏ¼Ì´Ù¸é ¾î´ÀÁ¤µµ Å°°ªÀÌ ÀâÇôÀÖ±ä ÇÒ °ÍÀÔ´Ï´Ù.
-------
Äõ¸®~¸¦ ¸ð´ÏÅ͸µ~ Çؼ, Å×À̺í~±¸Á¶¿Í where ´ÙÀ½¿¡ ³ª¿À´Â Äõ¸®~µéÀ» ºÐ¼®.
http://blog.pages.kr/242
±âŸ À¥¼¹ö~ÂÊ°ú ´Ù¸¥ ¼ºñ½º~µéµµ üũÇØ¾ß ÇÕ´Ï´Ù.
----------
Á¤¸» Çصµ Çصµ ¾ÈµÇ¸é, ¸®´ª½º~·Î °¥¾ÆŸ¼Å¾ßÁö¿ä.
°°Àº ¼¹ö~¶óµµ ¼º´ÉÂ÷ÀÌ°¡ Å®´Ï´Ù. -
¾ËÂùµ¹»ß 10-04-03 19:52
¼Ò½ºº¸±â
- ±»Àä.?
-
°ø´ë¿©ÀÚ 10-04-03 22:05
¼Ò½ºº¸±â
- ÀÌ·±°Å ÆÁÅØÀ¸·ÎÁ»...
-
1day1 10-04-03 22:44
¼Ò½ºº¸±â
- ±». Áñ°Üã±â
1 2 3 4 5 6 7 8 9 10