05/09/15 19:45:01
>>193
ちと１GBメモリでは、他も遣ってますので出すぎの設定と思われますが。
mysql-4.1.10a-2.RHEL4.1
まんまコンフをコピペすます。
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8