Compare Pastes

# /etc/mysql/50-distro-server.cnf: The global mysql configuration file.

# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations

[mysqld]

character-set-server				= utf8

user						= mysql

port						= 3306

socket						= /var/run/mysqld/mysqld.sock

pid-file					= /var/run/mysqld/mysql.pid

log-error					= /var/log/mysql/mysqld.err

basedir						= /usr

innodb_file_per_table				= 1

#      datadir						= /var/lib/mysql

datadir                                          = /mnt/d4tb/mysql

# azsx

innodb_buffer_pool_size				= 2G

innodb_log_file_size				= 512M

innodb_flush_log_at_trx_commit			= 2

skip-external-locking

lc_messages_dir					= /usr/share/mysql

#Set this to your desired error message language

lc_messages					= en_US

# security:

# using "localhost" in connects uses sockets by default

# skip-networking

# bind-address					= 127.0.0.1

log-bin

server-id					= 1

# point the following paths to different dedicated disks

tmpdir						= /tmp/