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

[thanasis]

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]

Duplicates can be removed. I believe its the last one that would be followed if they were different.

My.cnf can be very different and there are a LOT of different optimization settings. A good starting point is mysqltuner.pl, that script gives a lot of good advice.

https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

 

[cPanelLauren]

The advice provided by @GOT is basically identical to what I would have provided. There really is no correct way to configure the my.cnf as it can be different server to server depending on what your needs are.