Linuxの下でmysqlの重要な設定

428 ワード

変更/etc/my.cnfファイル
# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking

max_connections=1000

#    
wait_timeout =31536000
key_buffer = 16M
max_allowed_packet = 4M
table_cache = 2048
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 16M

#Case matters         
lower_case_table_names=1