mysql
Client API version 5.1.73

mevcut my.cnf
Alıntı
[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0


skip-locking # serverda sadece 1 MySQL varsa
skip-name-resolve
max_connections = 2000 # cok yogun sitelerde bu deger arttirilabilir (500)
thread_cache_size = 128
key_buffer = 1024M # 256
query_cache_type = 1
query_cache_size = 128M # 64
query_cache_limit = 8M # 4
table_cache = 2000 # cok fazla tablolu veritabanlarinda bu deger arttirilabilir
low_priority_updates = 1
### innodb varsa asagidaki ayarlari aciniz
innodb_buffer_pool_size=4096M #Innodb kullanimi cok ise 384M, 1024M e kadar arttirilabilir
innodb_additional_mem_pool_size=96M
innodb_thread_concurrency=8
innodb_flush_method=O_DIRECT



[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid