Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #
- # MariaDB database server configuration file.
- #
- # =================================================================
- # Base configuration courtesy of Open Query (http://openquery.com/)
- # For production use, case-specific preparation is still required.
- # 2009-10-07
- #
- # This is *not* an optimised config, merely a more sane baseline:
- # - InnoDB default (e.g., ACID out-of-the-box, same as on Windows)
- # - strict mode (for proper input checks, same as on Windows)
- # - various other useful settings
- # - make use of MariaDB/Percona/OurDelta enhancements/extensions
- #
- # For tuning assistance, please see http://openquery.com/services
- # =================================================================
- #
- # You can copy this file to one of:
- # - "/etc/mysql/my.cnf" to set global options,
- # - "~/.my.cnf" to set user-specific options.
- #
- # One can use all long options that the program supports.
- # Run program with --help to get a list of available options and with
- # --print-defaults to see which it would actually understand and use.
- #
- # For explanations see
- # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
- # This will be passed to all mysql clients
- # It has been reported that passwords should be enclosed with ticks/quotes
- # escpecially if they contain "#" chars...
- # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
- [client]
- port = 3306
- socket = /var/run/mysqld/mysqld.sock
- # Default is Latin1, if you need UTF-8 set this (also in server section)
- default-character-set = utf8
- # Here is entries for some specific programs
- # The following values assume you have at least 32M ram
- # This was formally known as [safe_mysqld]. Both versions are currently parsed.
- [mysqld_safe]
- socket = /var/run/mysqld/mysqld.sock
- nice = 0
- [mysqld]
- #
- # * Basic Settings
- #
- user = mysql
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- port = 3306
- basedir = /usr
- datadir = /var/lib/mysql
- tmpdir = /tmp
- language = /usr/share/mysql/english
- skip-external-locking
- #
- # * Character sets
- #
- # Default is Latin1, if you need UTF-8 set all this (also in client section)
- #
- #default-character-set = utf8
- #default-collation = utf8_general_ci
- character_set_server = utf8
- collation_server = utf8_general_ci
- #
- # Instead of skip-networking the default is now to listen only on
- # localhost which is more compatible and is not less secure.
- bind-address = 127.0.0.1
- #
- # * Fine Tuning
- #
- key_buffer_size = 32M
- max_allowed_packet = 4M
- thread_stack = 192K
- thread_cache_size = 8
- connect_timeout = 5
- wait_timeout = 30
- interactive_timeout = 120
- sort_buffer_size = 1M
- bulk_insert_buffer_size = 512K
- tmp_table_size = 512K
- max_heap_table_size = 2M
- myisam_recover = BACKUP
- max_connections = 75
- table_open_cache = 128
- thread_concurrency = 6
- myisam_sort_buffer_size = 1M
- concurrent_insert = 2
- read_buffer_size = 256K
- read_rnd_buffer_size = 256K
- #
- # * Query Cache Configuration
- #
- # Cache only tiny result sets, so we can fit more in the query cache.
- query_cache_limit = 256K
- query_cache_size = 8M
- # for more write intensive setups, set to DEMAND or OFF
- #query_cache_type = DEMAND
- #
- # * Logging and Replication
- #
- # Both location gets rotated by the cronjob.
- # Be aware that this log type is a performance killer.
- # As of 5.1 you can enable the log at runtime!
- #general_log_file = /var/log/mysql/mysql.log
- #general_log = 1
- #
- # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
- #
- # we do want to know about network errors and such
- log_warnings = 2
- #log-queries-not-using-indexes
- #log_slow_admin_statements
- #
- # The following can be used as easy to replay backup logs or for replication.
- # note: if you are setting up a replication slave, see README.Debian about
- # other settings you may need to change.
- #server-id = 1
- #report_host = master1
- #auto_increment_increment = 2
- #auto_increment_offset = 1
- #log_bin = /var/log/mysql/mariadb-bin
- #log_bin_index = /var/log/mysql/mariadb-bin.index
- # not fab for performance, but safer
- #sync_binlog = 1
- expire_logs_days = 10
- max_binlog_size = 100M
- # slaves
- #relay_log = /var/log/mysql/relay-bin
- #relay_log_index = /var/log/mysql/relay-bin.index
- #relay_log_info_file = /var/log/mysql/relay-bin.info
- #log_slave_updates
- #read_only
- #
- # If applications support it, this stricter sql_mode prevents some
- # mistakes like inserting invalid dates etc.
- #sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL
- #
- # * InnoDB
- #
- ## InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
- ## Read the manual for more InnoDB related options. There are many!
- #default_storage_engine = InnoDB
- ## you can't just change log file size, requires special procedure
- ##innodb_log_file_size = 50M
- #innodb_buffer_pool_size = 256M
- #innodb_log_buffer_size = 8M
- #innodb_file_per_table = 1
- #innodb_open_files = 400
- #innodb_io_capacity = 400
- #innodb_flush_method = O_DIRECT
- skip-innodb
- skip-federated
- skip-archive
- skip-blackhole
- skip-csv
- skip-mrg_myisam
- #
- # * Security Features
- #
- # Read the manual, too, if you want chroot!
- # chroot = /var/lib/mysql/
- #
- # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
- #
- # ssl-ca=/etc/mysql/cacert.pem
- # ssl-cert=/etc/mysql/server-cert.pem
- # ssl-key=/etc/mysql/server-key.pem
- [mariadb]
- skip-pbxt
- skip-pbxt_statistics
- skip-innodb_rseg
- skip-innodb_buffer_pool_pages
- skip-innodb_buffer_pool_pages_index
- skip-innodb_buffer_pool_pages_blob
- skip-innodb_trx
- skip-innodb_locks
- skip-innodb_lock_waits
- skip-innodb_cmp
- skip-innodb_cmp_reset
- skip-innodb_cmpmem
- skip-innodb_cmpmem_reset
- skip-innodb_table_stats
- skip-innodb_index_stats
- skip-innodb_sys_tables
- skip-innodb_sys_indexes
- skip-innodb_sys_stats
- skip-xtradb_admin_command
- skip-xtradb_enhancements
- [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/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement