Administrace komentářů

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /var/mysqltmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

#bind-address           = all
#0.0.0.0

key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8

myisam-recover         = BACKUP
max_connections        = 100
table_cache            = 64
thread_concurrency     = 10

query_cache_limit       = 16M
query_cache_size        = 16M
join_buffer_size        = 8M
tmp_table_size          = 64M
max_heap_table_size     = 64M

log_error = /var/log/mysql/error.log

server-id               = 7946917
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
binlog_ignore_db        = mysql
binlog_ignore_db        = phpmyadmin


[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

unix  2      [ ACC ]     STREAM     LISTENING     71538    /var/run/mysqld/mysqld.sock