X-Git-Url: https://git.tld-linux.org/?p=packages%2Fmysql.git;a=blobdiff_plain;f=mysqld.conf;fp=mysqld.conf;h=09808af2c7c9bc1441e6f344ef6644fba0b38f52;hp=c9da04de6779faa41945bc75a57661dedc86d4ea;hb=6d4f90321faeda56bdcd443d4f9054776bd9cfcf;hpb=da608bb7673207e574610ab4ceae97a34615966c diff --git a/mysqld.conf b/mysqld.conf index c9da04d..09808af 100644 --- a/mysqld.conf +++ b/mysqld.conf @@ -13,33 +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{MYSQL_MAJOR}/ca-cert.pem +#ssl-cert = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-cert.pem +#ssl-key = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-key.pem #ssl-cipher = DHE-RSA-AES256-SHA -#character-set-server=latin2 -#collation-server=latin2_general_ci -#skip-character-set-client-handshake - -# This variable controls the password hashing method used by the PASSWORD() -# function. It also influences password hashing performed by CREATE USER and -# GRANT statements that specify a password using an IDENTIFIED BY clause. -# http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_old_passwords -# Value | Password Hashing Method | Associated Authentication Plugin -# 0 | MySQL 4.1 native hashing | mysql_native_password -# 1 | Pre-4.1 ("old") hashing | mysql_old_password -# 2 | SHA-256 hashing | sha256_password -# If you set old_passwords=2, follow the instructions for using the sha256_password plugin at -# http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html -#old-passwords=0 - -# Don't use system locking -skip-external-locking - -# Disabling symbolic-links is recommended to prevent assorted security risks -symbolic-links=0 - # 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. @@ -54,64 +32,6 @@ skip-networking # Emergency option. Use only if you really need this. #skip-grant-tables -# http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_default-storage-engine -# Default storage engine is InnoDB since 5.5.5 -# You may revert to previous behaviour by specifiying MyISAM here -#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 @@ -123,19 +43,19 @@ skip-networking log-output = FILE # mysqld error log (stderr) -log-error = /var/log/mysql/mysqld.log -log-warnings = 2 +log-error = /var/log/mysql{MYSQL_MAJOR}/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{MYSQL_MAJOR}/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{MYSQL_MAJOR}/query.log # Log all updates. -#log-update = /var/log/mysql/update +#log-update = /var/log/mysql{MYSQL_MAJOR}/update # Log some extra information to update log #log-long-format @@ -146,96 +66,6 @@ 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 -# - -explicit_defaults_for_timestamp = true -#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 -# http://www.mysqlperformanceblog.com/2012/06/04/thread_concurrency-doesnt-do-what-you-expect/ -# thread_concurrency is deprecated, removed in 5.6.1 and works on old Solaris versions < 9 -#wait_timeout=28800 -#query_cache_size=8M -#query_cache_limit=1M - -# Fulltext search options -#ft_min_word_len=2 - -# Turn off nonstandard TIMESTAMP behaviors -# http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp -explicit_defaults_for_timestamp = true - -# -# 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. -# http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_myisam-recover-options -myisam-recover-options -# -#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_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 or status check for replications [client] user = mysql_sysadmin