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

thanasis

Well-Known Member
Nov 24, 2017
73
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,740
300
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,304
1,250
313
Houston
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.