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
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_size = 16M
query_cache_size = 12M
query_cache_min_res_unit = 2K
log-slow-queries = /var/log/slow.log
long_query_time = 2
tmp_table_size=32M
max_heap_table_size=32M
record_buffer=8M
sort_buffer_size=8M ## 1MB for every 1GB of RAM
read_buffer_size=8M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=8M ## 1MB for every 1GB of RAM
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
#[mysqldump]
#quick
max_allowed_packet=32M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8M
write_buffer=8M
[myisamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8M
write_buffer=8M
[mysqlhotcopy]
interactive-timeout
local-infile=0