--- /dev/null
+# MariaDB database server configuration file.\r
+#\r
+# You can copy this file to one of:\r
+# - "/etc/mysql/my.cnf" to set global options,\r
+# - "~/.my.cnf" to set user-specific options.\r
+#\r
+# One can use all long options that the program supports.\r
+# Run program with --help to get a list of available options and with\r
+# --print-defaults to see which it would actually understand and use.\r
+#\r
+# For explanations see\r
+# http://dev.mysql.com/doc/mysql/en/server-system-variables.html\r
+\r
+# This will be passed to all mysql clients\r
+# It has been reported that passwords should be enclosed with ticks/quotes\r
+# escpecially if they contain "#" chars...\r
+# Remember to edit /etc/mysql/debian.cnf when changing the socket location.\r
+[client]\r
+port = 3306\r
+socket = /var/run/mysqld/mysqld.sock\r
+\r
+# Here is entries for some specific programs\r
+# The following values assume you have at least 32M ram\r
+\r
+# This was formally known as [safe_mysqld]. Both versions are currently parsed.\r
+[mysqld_safe]\r
+socket = /var/run/mysqld/mysqld.sock\r
+nice = 0\r
+\r
+[mysqld]\r
+lower_case_table_names = 1\r
+skip-host-cache\r
+skip-name-resolve\r
+#\r
+# * Basic Settings\r
+#\r
+#user = mysql\r
+pid-file = /var/run/mysqld/mysqld.pid\r
+socket = /var/run/mysqld/mysqld.sock\r
+port = 3306\r
+basedir = /usr\r
+datadir = /var/lib/mysql\r
+tmpdir = /tmp\r
+lc_messages_dir = /usr/share/mysql\r
+lc_messages = en_US\r
+skip-external-locking\r
+#\r
+# Instead of skip-networking the default is now to listen only on\r
+# localhost which is more compatible and is not less secure.\r
+#bind-address = 127.0.0.1\r
+#\r
+# * Fine Tuning\r
+#\r
+max_connections = 100\r
+connect_timeout = 5\r
+wait_timeout = 600\r
+max_allowed_packet = 16M\r
+thread_cache_size = 128\r
+sort_buffer_size = 4M\r
+bulk_insert_buffer_size = 16M\r
+tmp_table_size = 32M\r
+max_heap_table_size = 32M\r
+#\r
+# * MyISAM\r
+#\r
+# This replaces the startup script and checks MyISAM tables if needed\r
+# the first time they are touched. On error, make copy and try a repair.\r
+myisam_recover_options = BACKUP\r
+key_buffer_size = 128M\r
+#open-files-limit = 2000\r
+table_open_cache = 400\r
+myisam_sort_buffer_size = 512M\r
+concurrent_insert = 2\r
+read_buffer_size = 2M\r
+read_rnd_buffer_size = 1M\r
+#\r
+# * Query Cache Configuration\r
+#\r
+# Cache only tiny result sets, so we can fit more in the query cache.\r
+query_cache_limit = 128K\r
+query_cache_size = 64M\r
+# for more write intensive setups, set to DEMAND or OFF\r
+#query_cache_type = DEMAND\r
+#\r
+# * Logging and Replication\r
+#\r
+# Both location gets rotated by the cronjob.\r
+# Be aware that this log type is a performance killer.\r
+# As of 5.1 you can enable the log at runtime!\r
+#general_log_file = /var/log/mysql/mysql.log\r
+#general_log = 1\r
+#\r
+# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.\r
+#\r
+# we do want to know about network errors and such\r
+#log_warnings = 2\r
+#\r
+# Enable the slow query log to see queries with especially long duration\r
+#slow_query_log[={0|1}]\r
+slow_query_log_file = /var/log/mysql/mariadb-slow.log\r
+long_query_time = 10\r
+#log_slow_rate_limit = 1000\r
+#log_slow_verbosity = query_plan\r
+\r
+#log-queries-not-using-indexes\r
+#log_slow_admin_statements\r
+#\r
+# The following can be used as easy to replay backup logs or for replication.\r
+# note: if you are setting up a replication slave, see README.Debian about\r
+# other settings you may need to change.\r
+#server-id = 1\r
+#report_host = master1\r
+#auto_increment_increment = 2\r
+#auto_increment_offset = 1\r
+#log_bin = /var/log/mysql/mariadb-bin\r
+#log_bin_index = /var/log/mysql/mariadb-bin.index\r
+# not fab for performance, but safer\r
+#sync_binlog = 1\r
+expire_logs_days = 10\r
+max_binlog_size = 100M\r
+# slaves\r
+#relay_log = /var/log/mysql/relay-bin\r
+#relay_log_index = /var/log/mysql/relay-bin.index\r
+#relay_log_info_file = /var/log/mysql/relay-bin.info\r
+#log_slave_updates\r
+#read_only\r
+#\r
+# If applications support it, this stricter sql_mode prevents some\r
+# mistakes like inserting invalid dates etc.\r
+#sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL\r
+#\r
+# * InnoDB\r
+#\r
+# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.\r
+# Read the manual for more InnoDB related options. There are many!\r
+default_storage_engine = InnoDB\r
+# you can't just change log file size, requires special procedure\r
+#innodb_log_file_size = 50M\r
+innodb_buffer_pool_size = 256M\r
+innodb_log_buffer_size = 8M\r
+innodb_file_per_table = 1\r
+innodb_open_files = 400\r
+innodb_io_capacity = 400\r
+innodb_flush_method = O_DIRECT\r
+#\r
+# * Security Features\r
+#\r
+# Read the manual, too, if you want chroot!\r
+# chroot = /var/lib/mysql/\r
+#\r
+# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".\r
+#\r
+# ssl-ca=/etc/mysql/cacert.pem\r
+# ssl-cert=/etc/mysql/server-cert.pem\r
+# ssl-key=/etc/mysql/server-key.pem\r
+\r
+#\r
+# * Galera-related settings\r
+#\r
+[galera]\r
+# Mandatory settings\r
+#wsrep_on=ON\r
+#wsrep_provider=\r
+#wsrep_cluster_address=\r
+#binlog_format=row\r
+#default_storage_engine=InnoDB\r
+#innodb_autoinc_lock_mode=2\r
+#\r
+# Allow server to accept connections on all interfaces.\r
+#\r
+#bind-address=0.0.0.0\r
+#\r
+# Optional setting\r
+#wsrep_slave_threads=1\r
+#innodb_flush_log_at_trx_commit=0\r
+\r
+[mysqldump]\r
+quick\r
+quote-names\r
+max_allowed_packet = 16M\r
+\r
+[mysql]\r
+#no-auto-rehash # faster start of mysql but no tab completion\r
+\r
+[isamchk]\r
+key_buffer = 16M\r
+\r
+#\r
+# * IMPORTANT: Additional settings that can override those from this file!\r
+# The files must end with '.cnf', otherwise they'll be ignored.\r
+#\r
+!includedir /etc/mysql/conf.d/
\ No newline at end of file
Code Review / vid.git / blobdiff