mahlas bence
"dedicated" e geç, gördüğün gibi
Historic max_used_connections = 141
şimdi önce , /var/log/un içinde
"mysql-slow-queries.log" dosya yarat ve chmod 666 ver,
ondan sonra my.cnf yi yeni optimizeye göre değiştir..
Alıntı
[mysqld]
skip-bdb
skip-innodb
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log-bin
expire_logs_days = 3
long_query_time=2
thread_cache_size = 384
max_connections = 190
query_cache_size=192M
query_cache_type=1
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
log_slow_queries = /var/log/mysql-slow-queries.log
log-queries-not-using-indexes
myisam_sort_buffer_size=64M
key_buffer_size=264M
table_cache : 64
join_buffer_size=2M
max_heap_table_size = 16M
tmp_table_size = 32M
low_priority_updates = 1
[safe_mysqld]
open_files_limit=1024
[mysql.server]
user=mysql
#basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
son olarakta mysql ü yeniden çalıştır...
rapor aldığında aşağıdaki yazmaması gerekiyor..yani 48 saaten önce çıktı alma..
Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations