Alıntı:
phidiess´isimli üyeden Alıntı
Selamlar Arkadaşlar,
2 adet serverım var aşağıda onlara ait my.cnf dosyalarının bilgileri var. Lütfen nasıl düzenleme yapacağım konusunda bilgi verirmisiniz.
Linux Fedocare Core 2.X
P4 3400 HT
3 GB Ram
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
query_cache_size=256M
connect_timeout=5
max_connections=300
thread_cache=100
thread_concurrency=120
thread_stack=512000
key_buffer_size=1024M
sort_buffer_size=4096M
read_buffer_size=4096M
old_passwords
max_allowed_packet=100M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
----------------------------------------------------------------------------------------------------------------------------------------------------
Linux Fedora Core 3.X
P4 3000 MHZ
3 GB Ram
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
query_cache_size=256M
connect_timeout=10
max_connections=400
thread_cache=100
thread_concurrency=120
thread_stack=512000
key_buffer_size=256M
sort_buffer_size=4096M
read_buffer_size=4096M
max_allowed_packet=128M
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
# These are additional parameters for mysql to support innodb tables.
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=20M
set-variable = innodb_additional_mem_pool_size=3M
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=1
Şimdiden teşekkürler arkadaşlar
|
Asagidaki sekilde duzenledim, bazi degerler cok yuksekti, bu degerler toplam fiziksel bellek (RAM) den buyuk oldugu icin serveri I/O swap (paging) e zorlamistir.
Ek olarak innodb kullanmiyorsan o kisimlari kaldirabiliriz.
Linux Fedocare Core 2.X
P4 3400 HT
3 GB Ram
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
query_cache_size=32M
query_cache_type=1
table_cache = 1024
connect_timeout=15
max_connections=500
key_buffer_size=512M
old_passwords
max_allowed_packet=100M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
----------------------------------------------------------------------------------------------------------------------------------------------------
Linux Fedora Core 3.X
P4 3000 MHZ
3 GB Ram
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
query_cache_size=32M
query_cache_type=1
table_cache = 1024
connect_timeout=15
max_connections=500
key_buffer_size=512M
max_allowed_packet=128M
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
# These are additional parameters for mysql to support innodb tables.
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=100M
set-variable = innodb_additional_mem_pool_size=3M
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=1