Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
*
HanIRCÀÇ #coffeenix ¹æ
[
Àåºñ ¹× ȸ¼± ÈÄ¿ø
]
> Forum <
IT ÀÏÁ¤
N
e
w
!
ÀÚµ¿È ÇÁ·ÎÁ§Æ®
HOME
>
µ¥ÀÌÅͺ£À̽º(database)
>
MySQL
µµ¿ò¸»
°Ë»ö :
»çÀÌÆ®
WHOIS
À¥¼¹ö Á¾·ù
´ë¿ë·® ½ÎÀÌÆ®¿¡¼ÀÇ MySQL (±Û¾´ÀÌ ¸ð¸§)
ÀÛ¼ºÀÏ : 2003/11/16 15:31
±Û¾´ÀÌ : ÁÁÀºÁøÈ£ (
http://coffeenix.net/
)
Á¶È¸¼ö : 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)
Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
[04/25]
±¹°¡
[04/24]
º¸Çè
[04/22]
Re: OpenSSL Ãë¾àÁ¡ Á¤¸®, Logjam(·Î±×Àë)¿¡¼ Heartbleed±îÁö
[04/21]
LET¡¯S START WITH ON
[04/21]
º¸Çè
[04/20]
Á¦ÁÖ
[04/20]
±¹³»
[04/19]
Á¦ÁÖ
[04/18]
??? ?????
[04/17]
???? onion ?????? -
[04/11]
±¹°¡
[04/10]
Stride Into Dream:
[03/20]
Re: ¿Â¶óÀΰÔÀÓÀÇ Á¾ÁÖ±¹ ´ëÇѹα¹
[10/20]
Cross Compiler ±ò
[07/14]
SSL ¬¡¬°
N
e
w
! ÃÖ±Ù¿¡ µî·ÏÇÑ ÆäÀÌÁö
KiCad EDA Suite project (Free/Libre/Open-Source EDA Suite) (CAD)
¿ÀÇÂij½ºÄÉÀ̵å ijµå (OpenCASCADE CAD)
QCad for Windows --- GNU GPL (Free Software)
The Hello World Collection
IPMI¸¦ È°¿ëÇÑ ¸®´ª½º ¼¹ö°ü¸®
DNS ¼³Á¤ °Ë»ç
nagiosgraph ¼³Ä¡ ¹æ¹ý
Slony-I ¼³Ä¡ ¹æ¹ý (postgresql replication tool)
Qmail±â¹ÝÀÇ Anti spam ½Ã½ºÅÛ ±¸ÃàÇϱâ
clusterssh
[ ÇÔ²²ÇÏ´Â »çÀÌÆ® ]
¿î¿µÁø :
ÁÁÀºÁøÈ£(truefeel)
, ¾ß¼ö(yasu), ¹ü³ÃÀÌ, sCag
2003³â 8¿ù 4ÀÏ~