Optimization of server for shared hosting 32gb RAM

[thinkbot]

Yes, but it's much more complicated, and you would have to update your varnish/nginx etc config if they make some major changes in their scripts
Couse each CMS needs different varnish/nginx setup

 

[alexistkd]

and what do u think about installing mariadb to replace mysql? will make any difference?

 

[thinkbot]

Not much

In shared environment, where you don't have access to the code of each site, you won't make it perfect
Your current mysql settings are good,

You should install Munin WHM plugin, and there you would have graphs with cpu, load, memory, disk usage, in general whole server resources usage

 

[goodmove]

[client]
port		= 3306
socket		= /var/lib/mysql/mysql.sock

[mysqld]
port		= 3306
socket		= /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 32M
table_open_cache = 2000
sort_buffer_size = 256K
read_buffer_size = 128K
join_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 16
query_cache_size = 64M
max_connections = 300
local-infile=0
open_files_limit = 16384

slow_query_log=1
slow_query_log_file=mysql-slow.log
long_query_time=0.1	

#skip-networking

server-id	= 1

innodb_buffer_pool_size = 150M
innodb_file_per_table=1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
#safe-updates

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Hi thinkbot

Would it be realistic to halve the values in youir suggested config for a 16GB server? If not, which variables would you suggest should remain the same regardless?

Norman

 

[thinkbot]

you need to run mysqltuner.pl and post the results here

Its more about the data, size of it, structure etc. then goes RAM, it needs to be adjusted to the data