´ë¿ë·® ½ÎÀÌÆ®¿¡¼ÀÇ MySQL (±Û¾´ÀÌ ¸ð¸§) | ÀÛ¼ºÀÏ : 2003/11/16 15:31 |
Á¶È¸¼ö : 7704 |
°¡Á®¿Â °÷ : http://unix.co.kr/stories.php?story=03/05/06/2804980 Ãâó : http://phps.net/ ±Û¾´ÀÌ°¡ ²ã´Ï´ÔÀÎÁöµµ Á¤È®ÇÏÁö ¾Ê½À´Ï´Ù. ¿Å°ÜÁö°í ¶Ç ¿Å°ÜÁö´Â °úÁ¤À» ÅëÇØ Ãâó¿Í ±Û¾´ÀÌ°¡ ºÒºÐ¸íÇØÁ³½À´Ï´Ù. ²ã´Ï´Ô²² ¸ÞÀϺ¸³» È®ÀÎÇغÁ¾ß°Ú½À´Ï´Ù. ---------------------------------------------------------------- ±Û¾´ÀÌ : ²ã´Ï(fuga@ggwuni.com) Á¦ ¸ñ : [ÆÁ] ´ë¿ë·® ½ÎÀÌÆ®¿¡¼ÀÇ MySQL ---------------------------------------------------------------- Æò±Õ ÀÌ¿ëÀÚ´Â Àß ¸ð¸£°Ú±¸.... ÇÏ·ç ÆäÀÌÁö ºä°¡ 600¸¸ ÆäÀÌÁö ºä ÀÔ´Ï´Ù... ¼¹ö´Â ´Þ¶û 4´ë... À¥ ¼¹ö 3´ë¿Í db ¼¹ö 1´ë... ¿ì¼± À¥¼¹öÀÇ Æ©´×Àº ¿©±â¼± Áý¾îÄ¡¿ìÁÒ... ÀÏ´Ü..... óÀ½¿¡ ³Ê¹« Ȳ´çÇß°í.. ¾î¿ÁÙ ¸ô¶ú½À´Ï´Ù.. ±×³ðÀÇ mysql ¿¬°á ¿¡·¯ ¶§¹®¿¡... »ç¿ëÀÚ°¡ ³Ê¹« ¸¹¾ÆÁü¿¡ µû¶ó¼ mysql Á¢¼Ó ¶ÇÇÑ Æø¹ßÀûÀ¸·Î Áõ°¡Ç߱⠶§¹®¿¡... ´õ ÀÌ»ó ¿¬°áÀ» ½ÃÅ°Áú ¸øÇÏ´õ±º¿ä... ±×·¡¼... ³¯¹ã ±î¸é¼... ÀÌ°Í Àú°Í ã¾Æº¸°í ¹°¾îº¸¸é¼... ¤Ð.¤Ð... °á±¹Àº ÇöÀçÀÇ db ¼¹ö¸¦ ¿ÏÀüÈ÷ Åë°·Î ¾þ¾î¹ö·È½À´Ï´Ù... RedHat 7.0 À» »ç¿ëÇÏ°í ÀÖ¾ú´Âµ¥.... ¿î¿µÃ¼Á¦´Â FreeBSD 4.2 ·Î ¹Ù²å½À´Ï´Ù... ¶ÇÇÑ Mysql ¼³Ä¡½Ã... ´ç±Ù ¼Ò½º ÄÄÆÄÀÏÀ» ÇßÁö¿ä... À̹ø¿£ È®½ÇÈ÷ Çϱâ À§Çؼ ¾Æ¿¹... pgcc ¸¦ ÀÌ¿ëÇؼ Á¤Àû ÄÄÆÄÀÏ Çß½À´Ï´Ù... ±×·¡¼..... ±×´ÙÀ½... Àü ÀÌ·¸°Ô Mysql À» ¼³Á¤Çß½À´Ï´Ù... ÀÌ ºÎºÐÀÌ ÇÙ½ÉÀÌ°ÚÁö¿ä... ¼¹ö´Â... Intel P-III 600Mhz Dual Ram : 1GB I/O : ½ºÄ«½Ã NetWork : 100M Shared ÀÔ´Ï´Ù... ¿ì¼±... /etc/my.cnf ¶ó´Â ÆÄÀÏÀ» ¸¸µå¼¼¿ä.. vi /etc/my.cnf ÀÌ ÆÄÀÏÀº mysql µ¥¸óÀÌ ½ÇÇàµÉ¶§ °¡Àå ¸ÕÀú ã´Â ÆÄÀÏÀÔ´Ï´Ù.. ÀϹÝÀûÀ¸·Î ¿©·¯ºÐµéÀÇ ¼¹ö¿¡´Â ÀÌ ÆÄÀÏÀÌ ´ç¿¬È÷ ¾øÀ»°Ì´Ï´Ù.. ±×·³ mysql Àº µðÆúÆ® ¿É¼ÇÀ¸·Î µ¥¸óÀ» ½ÃÀÛÇÕ´Ï´Ù... Áö±Ý ºÎÅÍ À§ ÆÄÀÏÀ» ÀÛ¼ºÇÏ°Ú½À´Ï´Ù.. #======================================================= # /etc/my.cnf [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=4M set-variable = record_buffer=4M set-variable = thread_cache=8 set-variable = thread_concurrency=4 # CPU °¹¼öÀÇ 2¹è¸¦ ÀûÀ¸¼¼¿ä set-variable = myisam_sort_buffer_size=64M set-variable = max_connections=400 log-update [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read-buffer=2M set-variable = write-buffer=2M [myisamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read-buffer=2M set-variable = write-buffer=2M ÀÌ·¸°Ô ÀÛ¼ºÇϽðí ÀúÀåÇϼ¼¿ä... Âü°í·Î... ¸Þ¸ð¸®°¡ ÃÖ¼ÒÇÑ 1G ÀÌ»óÀº µÈ´Ù´Â °¡Á¤ÇÏ¿¡ Àû´Â ¿É¼ÇÀÔ´Ï´Ù... ±× ´ÙÀ½¿¡... ¿©·¯ºÐµéÀÇ /etc/rc.d/rc.local ÆÄÀÏ¿¡ ´ÙÀ½°ú °°ÀÌ Àû¾îÁÖ¼¼¿ä... bin/sh -c 'cd /mysqlÆнº ; ./bin/safe_mysqld &' ~~~~~~~~~~ (¿¹.. /usr/local/mysql ) Âü°í·Î Àü À§¿Í °°ÀÌ ÇÏÁö ¾Ê¾Ò½À´Ï´Ù... Àü FreeBSD À̱⠶§¹®¿¡... À§ÀÇ °ÍÀº ·¹µåÇÞ °è¿À϶§ÀÇ Àû¿ëµÇ´Â °ÍÀÔ´Ï´Ù... ±×·³.. ÀÌÁ¦ ¼Ë´Ù¿î ½ÃÅ°°í ´Ù½Ã safe_mysqld ¸¦ ÇÒ¶§¿¡µµ ÀÚµ¿À¸·Î /etc/my.cnf ÆÄÀÏÀ» Àоîµå¸± °ÍÀÔ´Ï´Ù.. ±× ´ÙÀ½... ÀÌ°Ç ¹¹.. ¾î¿ ¼ö ¾ø´Â °ÍÀε¥... ÇöÀç ÀúÈñ À¥ ÇÁ·Î±×·¥ÀÇ ¸ðµç php ÇÁ·Î±×·¥¿¡¼... select ³ª.. ±âŸ µîµî.... ¾à°£ º¹ÀâÇÑ°ÍÀº ¸ðµÎ UDF ·Î ¹Ù²Ù¾ú½À´Ï´Ù... ÀÏÀÏÈ÷ UDF ·Î ¹Ù²Û´Ù´Â°ÍÀº ±²ÀåÈ÷ °íÅ뽺·´°í ¾î·Á¿î ÀÛ¾÷À̾úÀ¸³ª.. ¼º´ÉÀº °ÅÀÇ È¯»óÀûÀÌ´õ±º¿ä... ¾î·µç.... ÀÌ·¸°Ô Çؼ... ÇöÀç 600¸¸ ÆäÀÌÁö ºä°¡ ÀϾ¶§...(db Á¢¼Ó ºÎºÐÀÌ ¾ÆÁÖ ¸¹½À´Ï´Ù,,) ¾Æ¹«·± ¹®Á¦°¡ ¾ø½À´Ï´Ù... »õº® 4½Ã Á¤µµ¿¡ ¼ø°£ÀûÀ¸·Î ´Ù½Ã µðºñ¸¦ ¸®·Îµå ½ÃÅ°°í ÀÖ½À´Ï´Ù.. ¾î·µç..... Áö±Ý±îÁö ¾Æ¹«·± ¹®Á¦¾øÀÌ Á¤¸» Àß µ¹¾Æ°¡°í ÀÖ½À´Ï´Ù.. ÇöÀç DB ¼¹ö¿¡´Â 5°³ÀÇ database °¡ ÀÖÀ¸¸ç ±×ÁßÀÇ 4°³´Â 60°³ Á¤µµÀÇ Å×À̺íÀÌ ÀÖÀ¸¸ç ³ª¸ÓÁö 1°³´Â 400°³ÀÇ Å×À̺íÀÌ ÀÖ½À´Ï´Ù.... ¸ðµç µ¥ÀÌŸ º£À̽ºÀÇ ÃÑ ·¹ÄÚµå ¼ö´Â.... ÇöÀç ¾à 1200¸¸°³ Á¤µµ°¡ ÀÖ½À´Ï´Ù... ¼¹ö´Â ÇöÀç ¹Ì±¹¿¡ ÀÖ½À´Ï´Ù.. ÇÑ°¡Áö ³î¶ó¿î°ÍÀº UDF ÀÇ »ç¿ëÀ¸·Î Á¤¸» ³î¶øµµ·Ï ÁÁ¾ÆÁø ¼º´É ÀÔ´Ï´Ù.... ´ÙÇàÈ÷ °¡±î¿î°÷¿¡ C ¾ð¾î¸¦ ¾ÆÁÖ Àß ÇÏ´Â »ç¶÷ÀÌ ÀÖ¾î¼ ¸¹Àº µµ¿òÀ» ¹Þ¾ÒÁö¿ä... ÈÞ~~~ ÇÑ°¡Áö Àý½ÇÈ÷ ´À³¤°ÍÀº..... PHP ·Î À¥ ÇÁ·Î±×·¥À» Çߴµ¥.... °á±¹Àº C ¾ð¾î°¡ ¾Æ´Ï¾úÀ¸¸é... ´õÀÌ»óÀÇ ¼ºñ½º´Â ºÒ°¡´É ÇßÀ» °ÍÀ̶ó´Â Á¡ ÀÔ´Ï´Ù... ¹°·Ð À̹ۿ¡... Å« ´ÜÀÏ ÆÄÀÏÀÇ Ã³¸®¿Í... db ÆÄÀÏ Çϳª°¡ 4G..¤Ð.¤Ð... ±âŸ Áß¿äÇÑ ¹®Á¦µéÀÌ ¸¹ÀÌ ÀÖ½À´Ï´Ù... ÀÌ°ÍÀº... ¿ì¸® ¿£Áö´Ï¾î°¡ ÇØ°áÇÑ ¹®Á¦À̱⠶§¹®¿¡... Àü ¹«½ÄÇؼ Àß ¸ð¸£°Ú³×¿ä.... Çѹø ¹°¾îº¼²²¿ä..... ´ÙÀ½¿¡´Â myisam »ç¿ë°ú ´Ù¸¥ ÆÁµéÀ» ¿Ã¸®µµ·Ï ÇÏ°Ú½À´Ï´Ù... ±×·³.... ¾à°£ÀÇ µµ¿òÀÌ µÇ¾ú±â¸¦ ºô¸ç.. ²ã´Ï(fuga@ggwuni.com) |
Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ / URL : http://coffeenix.net/board_view.php?bd_code=128 |