PHP- Kodu:
skip-locking # serverda sadece 1 MySQL varsa
skip-name-resolve
max_connections = 500 # cok yogun sitelerde bu deger arttirilabilir
thread_cache_size = 128
key_buffer = 64M
query_cache_type = 1
query_cache_size = 32M
query_cache_limit = 4M
table_cache = 2000 # cok fazla tablolu veritabanlarinda bu deger arttirilabilir
low_priority_updates = 1
### innodb varsa asagidaki ayarlari aciniz
#innodb_buffer_pool_size=64M
#innodb_additional_mem_pool_size=32M
#innodb_thread_concurrency=8
#innodb_flush_method=O_DIRECT
yukardeki kodu my.cnf ye uyguladım service mysql restart edince aşağıdaki hatayı veriyor iyinet yardımcı olabilirmisin
PHP- Kodu:
[root@74 etc]# service mysql restart
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
Shutting down MySQL... [ OK ]
error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
Starting MySQL................................... [FAILED]