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