MYSQL
HOME > DB > MYSQL
2011.05.27 / 15:43

my.ini ¼³Á¤ ³»¿ë

¸Þ¸®¾ß½º
Ãßõ ¼ö 193
Á¦¸ñ¾øÀ½

ÇöÀç ÀúÀÇ ½Ã½ºÅÛ¿¡¼­ ¼³Á¤ÇÑ my.ini ÆÄÀÏ ³»¿ëÀÔ´Ï´Ù.

 

OS - Windows 2000 Advance Server

MySQL - 5.0.27

 

[client]
port=3306

 

[mysql]
default-character-set=euckr

 

[mysqld]
port=3306
basedir="C:/MySQL/MySQL Server 5.0/"
datadir="C:/MySQL/MySQL Server 5.0/Data/"
default-character-set=euckr
language="C:/MySQL/MySQL Server 5.0/share/korean"
character-set-client-handshake=FALSE
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=52M
thread_cache_size=8


#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=103M
key_buffer_size=85M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K


#*** INNODB Specific options ***
innodb_data_home_dir="C:/MySQL/MySQL Server 5.0/ibdata/"
innodb_log_group_home_dir="C:/MySQL/MySQL Server 5.0/iblogs"
innodb_data_file_path=ibdata1:10M:autoextend:max:1000M
innodb_additional_mem_pool_size=3469K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=256M
innodb_log_file_size=40M
innodb_thread_concurrency=8
innodb_log_archive=0