Mysql /etc/my.cnf default settings 11.5.30

[ZopfWare]

Is this all there is to my.cnf these days?

[mysqld]
bind-address=127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


I'm having mysql usage problems and seem to recall this file had a lot more settings in it.

Any comments?

 

[Nikolay.]

You'd be surprised to hear, but depending on MySQL variant this file may even be empty or absent (e.g., for MariaDB). Other than that looks OK to me.

 

[lvalics]

You can get from this page (http://www.grafxsoftware.com/faq.php/HOW-TO-Setup-a-PLESK-Dedicated-Server/1/4/) my.cnf model and just change some values depend on your memory. Of course this is not perfect, but it work on 90% of the cases.