/etc/my.cnf optimization

view full story

http://forums.cpanel.net – Hello, We have websites that are mainly php/mysql driven and website is getting good amount of traffic. Please suggest changes to improve the performance. Server Spec is: Intel Xeon CPU E3-1230 V2 @ 3.30GHz with 8GB of Ram Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock max_allowed_packet=100M thread_stack=3M max_connections=600 max_user_connections=50 ft_min_word_len=3 wait_timeout=50 connect_timeout =30 interactive-timeout = 30 skip-locking skip-innodb table_cache = 1500K read_rnd_buffer_size = 8M myisam_sort_buffer_size = 24M thread_cache = 8 thread_cache_s (HowTos)