X-Git-Url: https://git.tld-linux.org/?p=packages%2Fmysql.git;a=blobdiff_plain;f=mysqld.conf;h=c9da04de6779faa41945bc75a57661dedc86d4ea;hp=c4f7331dfd3099d2af088f45e118d3108d2810a3;hb=HEAD;hpb=bfeeb8ad08433b4da25106914f8cb1f1810bedf5 diff --git a/mysqld.conf b/mysqld.conf index c4f7331..0e5fbc2 100644 --- a/mysqld.conf +++ b/mysqld.conf @@ -3,7 +3,6 @@ # # One can use all long options that the mysqld supports. # Run mysqld with --help to get a whole list of available options -# $Id$ # This section must be the first! [mysqld] @@ -14,28 +13,11 @@ port = 3306 user = mysql # ssl options -#ssl-ca = /etc/ssl/certs/mysql/ca-cert.pem -#ssl-cert = /etc/ssl/certs/mysql/server-cert.pem -#ssl-key = /etc/ssl/certs/mysql/server-key.pem +#ssl-ca = /etc/ssl/certs/mysql-@mysqlversion@/ca-cert.pem +#ssl-cert = /etc/ssl/certs/mysql-@mysqlversion@/server-cert.pem +#ssl-key = /etc/ssl/certs/mysql-@mysqlversion@/server-key.pem #ssl-cipher = DHE-RSA-AES256-SHA -#character-set-server=latin2 -#collation-server=latin2_general_ci -#skip-character-set-client-handshake - -# Use passwords compatible with old 4.0 mysqld -#old-passwords - -# Don't use system locking -skip-external-locking - -# Disabling symbolic-links is recommended to prevent assorted security risks -symbolic-links=0 - -# Default storage engine is InnoDB since 5.5.5 -# You may revert to previous behaviour by specifiying MyISAM here -#default-storage-engine=InnoDB - # Don't listen on a TCP/IP port at all. This is a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets. @@ -50,79 +32,30 @@ skip-networking # Emergency option. Use only if you really need this. #skip-grant-tables -# http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine -#default-storage-engine=MyISAM - -# Replication Master Server (default) -# binary logging is required for replication -#log-bin=mysql-bin - -# max size of master binlog files -#max_binlog_size=256M - -# If non-zero, binary logs will be purged after expire_logs_days days; possible -# purges happen at startup and at binary log rotation. -#expire-logs-days=30 - -# Normally, a slave does not log to its own binary log any updates that are -# received from a master server. This option tells the slave to log the updates -# performed by its SQL thread to its own binary log. For this option to have -# any effect, the slave must also be started with the --log-bin option to -# enable binary logging. --log-slave-updates is used when you want to chain -# replication servers. -#log-slave-updates - -# required unique id between 1 and 2^32 - 1 -# defaults to 1 if master-host is not set but will not function as a master if omitted -#server-id=2 - -# To set up N master servers, set the variables like this: -# Set auto_increment_increment to N on each master. -# Set each of the N masters to have a different auto_increment_offset, using the values 1, 2, ..., N -#auto-increment-offset=1 -#auto-increment-increment=2 - -# databases to be included in binlog -#binlog-do-db=db1 -# or excluded -#binlog-ignore-db=mysql -#binlog-ignore-db=test - -# slave setup -#relay-log=slave-relay-bin -#report-host=db-slave.example.org - -# skip startup of slave -#skip-slave-start - -# master does not ignore them, but we do -#replicate-ignore-db=mysql -#replicate-ignore-db=test -#replicate-ignore-table=db1.tbl1 -#replicate-ignore-table=db2.tbl2 - -#replicate-rewrite-db=delfi->delfi_ro - -# replication local log -#max_relay_log_size=256M - +# https://dev.mysql.com/doc/refman/5.6/en/log-destinations.html # global option where logs be written +# affects slow-query-log, general-log direcives +# Possible values: FILE, TABLE +# NOTE: when using table, you can switch to MyISAM, but the contents is still +# not replicated, also mysqldump will not dump data, only create table +# statements +#log-output = TABLE log-output = FILE # mysqld error log (stderr) -log-error = /var/log/mysql/mysqld.log -log-warnings = 2 +log-error = /var/log/mysql/@mysqlversion@/mysqld.log +log-error-verbosity = 2 # Log slow queries slow-query-log -slow-query-log_file = /var/log/mysql/slow.log +slow-query-log-file = /var/log/mysql/@mysqlversion@/slow.log # Log connections and queries. It slows down MySQL so it's disabled by default #general-log -#general-log-file = /var/log/mysql/query.log +#general-log-file = /var/log/mysql/@mysqlversion/query.log # Log all updates. -#log-update = /var/log/mysql/update +#log-update = /var/log/mysql/@mysqlversion@/update # Log some extra information to update log #log-long-format @@ -133,97 +66,7 @@ slow-query-log_file = /var/log/mysql/slow.log # colon (:), in this case they are used in a round-robin fashion. #tmpdir = /var/tmp -# -# Internal server variables -# - -#back_log=5 -#connect_timeout=5 -#delayed_insert_timeout=300 -#delayed_insert_limit=100 -#flush_time=0 -#join_buffer_size=131072 -#key_buffer_size=8M -#read_rnd_buffer_size=256K -#read_buffer_size=132K -#long_query_time=10 -#max_allowed_packet=1M -#max_connections=100 -#max_user_connections=0 -#max_connect_errors=10 -#max_delayed_threads=20 -#delayed_queue_size=1000 -#max_join_size=4294967295 -#max_sort_length=1024 -#max_write_lock_count=4294967295 -#net_buffer_length=16384 -#record_buffer=131072 -#sort_buffer_size=2M -#table_cache=64 -#tmp_table_size=1M -#max_heap_table_size=32M -#thread_cache_size=16 -#thread_stack=65536 -# Try number of CPU's*2 -#thread_concurrency=8 -#wait_timeout=28800 -#query_cache_size=8M -#query_cache_limit=1M - -# Fulltext search options -#ft_min_word_len=2 - -# -# MyISAM tables options -# - -# Don't flush key buffers between writes for any MyISAM -# set this if you have dedicated slave server where writes aren't important -#delay-key-write-for-all-tables - -# Repair automatically on open if the table wasn't closed properly. -myisam-recover -# -#myisam_sort_buffer_size=4M - - -# To completely disable InnoDB, use this option -# this makes all innodb options being unknown options (including skip-innodb) -# @deprecated -#ignore-builtin-innodb - -# -# InnoDB tables options (see MySQL manual) -# -#skip-innodb - -# http://stackoverflow.com/questions/2646373/mysql-data-file-wont-shrink -# http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html -#innodb_file_per_table - -# these are actual defaults (as of 5.0.26) -innodb_data_home_dir = @clusterdir@/mysqldb/db -innodb_data_file_path = ibdata1:10M:autoextend -innodb_mirrored_log_groups=1 -innodb_log_group_home_dir = @clusterdir@/mysqldb/db -innodb_log_files_in_group=2 -innodb_log_file_size=5M -innodb_log_buffer_size=1M - -#innodb_flush_log_at_trx_commit=1 -#innodb_log_arch_dir = @clusterdir@/innodb/log -#innodb_log_archive=0 -#innodb_buffer_pool_size=80M -#innodb_additional_mem_pool_size=10M -#innodb_file_io_threads=4 -#innodb_lock_wait_timeout=50 - -# used for logs rotation -[mysqladmin] +# used for logs rotation or status check for replications +[client] user = mysql_sysadmin password = - -# used by initscript to fetch slave status -[mysql] -user = mysql -password =