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

thanasis

• November 22, 2018 16:00

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

  • November 22, 2018 23:58

  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.

  0
• 

  cPanelLauren

  • November 26, 2018 17:03

  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.

  0

Please sign in to leave a comment.