mysql 최적화 my.ini 파일 설정

[mysqld]
datadir=/home/mysql/
tmpdir=/home/mysqltmp
#max_connections = 175 #was 175
max_connections = 80
#max_connect_errors = 350 #was 250
max_connect_errors = 250
safe-show-database
skip-locking
key_buffer = 1024M # was 128M
max_allowed_packet = 6M
myisam_sort_buffer_size = 64M

#old settings, for 900 ish max maxconn
#sort_buffer_size = 32M
#read_buffer_size = 32M
#read_rnd_buffer_size = 32M

sort_buffer_size = 5M
read_buffer_size = 5M
read_rnd_buffer_size = 5M

query_cache_size= 1024M
query_cache_limit= 16M
max_heap_table_size = 128M
tmp_table_size = 128M
thread_concurrency = 16
wait_timeout = 10
innodb_file_per_table
innodb_log_file_size = 10485760
open_files_limit = 8192
low_priority_updates = 1 
#log_slow_queries = /var/log/mysql_slow.log
#log_queries_not_using_indexes = 1
#slow_queries_log_file = /var/log/mysql_slow.log
memory_limit = 64M 
# who set these? these are NOT memory settings, but rather integer settings.
#table_cache = 1024M
#thread_cache_size = 8M

table_cache = 512
thread_cache_size = 8

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

Autoset 최적화 my.ini

[client]

port=3306

[mysql]

default-character-set=utf8

[mysqld]

port=3306

basedir=C:/AutoSet8/Server/MySQL5/

datadir=C:/AutoSet8/Server/MySQL5/Data/

init_connect=SET NAMES utf8

character_set_server=utf8

collation_server=utf8_general_ci

socket=C:/AutoSet8/Server/temp/mysql.sock

max_connect_errors = 250

key_buffer=1024M

max_allowed_packet=6M

character-set-server=utf8

default-storage-engine=MyISAM

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=80

query_cache_size=1024M

query_cache_limit=16M

tmp_table_size=128M

thread_cache_size=32M

myisam_max_sort_file_size=64M

myisam_sort_buffer_size=64M

key_buffer_size=5M

read_buffer_size=5M

read_rnd_buffer_size=5M

sort_buffer_size=5M

thread_concurrency = 16

wait_timeout = 10

innodb_data_home_dir="C:/AutoSet8/Server/MySQL5/Data/"

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=1M

innodb_buffer_pool_size=16M

innodb_log_file_size=10M

innodb_thread_concurrency=8

[mysqldump]

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[isamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M

[myisamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M