My.cnf examples

From Wiki
Revision as of 14:01, 15 April 2015 by Admin (Talk | contribs) (Created page with '<pre> [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 bind-address=127.0.0.1 default-storage-engine = InnoDB log-bin=/tmp/mysql-binar…')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
bind-address=127.0.0.1
default-storage-engine = InnoDB
log-bin=/tmp/mysql-binary-log
external-locking 
max_connections = 250
max_user_connections = 100

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