🌟BugsBunny🌟 2011. 5. 14. 15:39


β˜†β˜†β˜†β˜†β˜†β˜†β˜†β˜†β˜† 버전별 컴파일 μ„€μΉ˜ λ‚΄μš© β˜†β˜†β˜†β˜†β˜†β˜†β˜†β˜†β˜†

◐◑◐◑◐◑ MySQL_3 버전 ◐◑◐◑◐◑
./configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-mysqld-user="mysql" \
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--with-charset=euc_kr

◐◑◐◑◐◑ MySQL_4 버전 ◐◑◐◑◐◑
./configure --prefix=/usr/local/dbsql \
--localstatedir=/usr/local/dbsql/data \
--with-mysqld-user="dbadmin" \
--with-unix-socket-path=/var/lib/dbsql/mysql.sock \
--with-charset=euckr

◐◑◐◑◐◑ MySQL_5 버전 ◐◑◐◑◐◑
./configure --prefix=/usr/local/mysql --localstatedir=/home/mysql/data \
--sysconfdir=/etc --disable-shared --with-mysqld-user=mysql \
--with-innodb --without-isam --without-debug \
--with-unix-socket-path=/home/mysql/mysql.sock --with-charset=euckr

◐◑◐◑◐◑ MySQL_6 버전 ◐◑◐◑◐◑
./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql_data \
--sysconfdir=/etc --disable-shared  --with-mysqld-user=mysql \
--with-innodb --without-isam --without-debug \
--with-unix-socket-path=/usr/local/mysql_data/mysql.sock --with-charset=utf8

◐◑◐◑◐◑ [CentOS 5] MySQL 6 λ‚΄κ°€ 주둜 μ‚¬μš© ν•˜λŠ” μ˜΅μ…˜ ◐◑◐◑◐◑
===========================================================================
mysql-6.0.10-alpha]# ./configure --prefix=/usr/local/dbsql \
--localstatedir=/usr/local/dbsql/dba_data \
--with-unix-socket-path=/usr/local/dbsql/dba_data/mysql.sock \
--sysconfdir=/usr/local/etc --with-mysqld-user=dbadmin \
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static \
--enable-assembler --with-charset=utf8 --enable-thread-safe-client \
--without-debug
============================================================================
#############################################
β–£β–£β–£β–£β–£β–£ configure μ˜΅μ…˜ μ„€λͺ… β–£β–£β–£β–£β–£β–£
#############################################
=============================================================================
--prefix=/usr/local/mysql ==> μ„€μΉ˜λ  폴더 μ§€μ •
--localstatedir=/home/userdb/data ==> μ‹€μ œ Databaseκ°€ 저정될 μ£Όμ†Œμž…λ‹ˆλ‹€. defalut μ‹œ /usr/local/var 이닀.
--with-unix-socket-path=/home/userdb/mysql.sock ==> sock의 경둜λ₯Ό μ„€μ •.
--sysconfdir=/usr/local/etc ==> my.cnf ν™˜κ²½μ„€μ • 파일 생성 경둜λ₯Ό μ§€μ •.
--with-mysqld-user=mysql ==> mysql 데λͺ¬μ˜ μ‹€ν–‰ μœ μ €λ₯Ό μ§€μ •.
--with-mysqld-ldflags=-all-static ==> μ •μ μœΌλ‘œ mysql을 컴파일 적용.
--with-client-ldflags=-all-static ==> μ •μ μœΌλ‘œ mysql을 컴파일 적용.
--enable-assembler ==> 쒀더 μ΅œμ ν™”λœ λ°”μ΄λ„ˆλ¦¬μ½”λ“œλ₯Ό 생성.
--with-charset=utf8  ==> DataBase 언어셋을 μ„€μ •.
--with-collation=utf8_general_ci ==> DataBase μ •λ ¬ ν• λ•Œ μ‚¬μš©λ˜λŠ” μ–Έμ–΄λ₯Ό
μ§€μ •ν•œλ‹€.<charsetκ³Ό λ™μΌν•˜κ²Œ μ„€μ •>
--with-extra-charsets ==> defalt μ–Έμ–΄ 외에 λ‹€λ₯Έ 언어셋을 μΆ”κ°€.
--without-debug ==> debug λ₯Ό μ‚¬μš© ν•˜μ§€ μ•ŠλŠ”λ‹€.
--without-bench ==> 벀치마크 κ΄€λž€νŒŒμΌμ„ μƒμ„±ν•˜μ§€ μ•ŠλŠ”λ‹€.
--with-plugins=innobase innodb νŠΈλžœμ μ…˜ μ‚¬μš© μžμ„Έν•œ 링크
--enable-thread-safe-client  ==> APM μ—°λ™μ‹œ 적용
--with-charset=CHARSET ==> euc_kr
<dec8, dos, euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru
koi8_ukr, latin1,
latin2, sjis, swe7, tis620, ujis, usa7>
========================================================================