2 VPS at the same company, different my.cnf , what is the correct?

thanasis

Well-Known Member
Nov 24, 2017
69
4
8
Greece
cPanel Access Level
Root Administrator
Hello,
i have 2 VPS at the same hosting company, with same CentOS 7.5, with the same CPU (E5-2630v4 10 core), with the same RAM (60GB), with the same SSD (1.6TB), with same MySQL 5.7 version, but with different default my.cnf settings...

Please have a look.

1st VPS my.cnf
--------------------
[mysqld]
performance-schema=0 (duplicate)
datadir=/var/lib/mysql (extra)
socket=/var/lib/mysql/mysql.sock (extra)
performance-schema=0 (duplicate)
symbolic-links=0 (extra)
bind-address=127.0.0.1
performance-schema=0 (duplicate)
log-error=/var/log/mysqld.log (extra)
pid-file=/var/run/mysqld/mysqld.pid (extra)
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=24000


2nd VPS my.cnf
--------------------
[mysqld]
innodb_file_per_table=1
default-storage-engine=MyISAM
performance-schema=0
max_allowed_packet=268435456
open_files_limit=24000
bind-address=127.0.0.1

1) As you can see the 1st have some duplicate lines . Can i safety remove it?
2) Also there are some extra lines. Are these lines usefull? Shall i keep them?

And they suggest me to activate mysql query cache:
query_cache_type = 1
query_cache_size = 134217728
3) With above hardware, am i right with these values ?

Thank you
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,542
207
343
Chesapeake, VA
cPanel Access Level
DataCenter Provider