Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ cat /etc/mysql/my.cnf
- [client]
- port = 3306
- socket = /var/run/mysqld/mysqld.sock
- default-character-set = utf8
- [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 = /tmp
- default_storage_engine = InnoDB
- lc_messages_dir = /usr/share/mysql
- lc_messages = en_US
- character_set_server = utf8
- collation_server = utf8_general_ci
- skip-external-locking
- skip-name-resolve
- connect_timeout = 120
- join_buffer_size = 1M
- key_buffer = 2M
- key_buffer_size = 61M
- log_warnings = 2
- max_allowed_packet = 32M
- max_connect_errors = 30
- max_connections = 30
- max_user_connections = 30
- myisam_sort_buffer_size = 1024K
- query_cache_limit = 128K
- query_cache_size = 64M
- query_cache_type = 1
- read_buffer_size = 8M
- read_rnd_buffer_size = 4M
- sort_buffer_size = 128K
- bulk_insert_buffer_size = 128K
- table_open_cache = 64
- table_definition_cache = 512
- table_cache = 128
- thread_stack = 256K
- thread_cache_size = 128
- thread_concurrency = 8
- wait_timeout = 3600
- tmp_table_size = 64M
- max_heap_table_size = 128M
- low_priority_updates = 1
- concurrent_insert = 2
- max_tmp_tables = 16384
- server-id = 8
- myisam-recover = BACKUP
- #log_bin = /var/log/mysql/mariadb-bin
- #log_bin_index = /var/log/mysql/mariadb-bin.index
- #expire_logs_days = 1
- #max_binlog_size = 100M
- open_files_limit = 196608
- #slow_query_log = 1
- #long_query_time = 10
- #slow_query_log_file = /var/log/mysql/sql-slow-query.log
- #log_queries_not_using_indexes
- # * 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!
- sql_mode = NO_ENGINE_SUBSTITUTION
- # you can't just change log file size, requires special procedure
- #innodb_log_file_size = 50M
- innodb_buffer_pool_size = 61M
- innodb_log_buffer_size = 4M
- innodb_file_per_table = 1
- innodb_open_files = 256
- innodb_io_capacity = 512
- innodb_flush_method = O_DIRECT
- innodb_flush_log_at_trx_commit = 2
- innodb_thread_concurrency = 8
- #innodb_lazy_drop_table = 1
- innodb_lock_wait_timeout = 120
- [mysqld_safe]
- socket = /var/run/mysqld/mysqld.sock
- nice = 0
- open_files_limit = 196608
- syslog
- [mysqldump]
- quick
- max_allowed_packet = 32M
- quote-names
- [mysql]
- no-auto-rehash
- [myisamchk]
- key_buffer = 1M
- sort_buffer_size = 64K
- read_buffer = 4M
- write_buffer = 4M
- [isamchk]
- key_buffer = 1M
- sort_buffer_size = 64K
- read_buffer = 4M
- write_buffer = 4M
- [mysqlhotcopy]
- interactive-timeout
- !includedir /etc/mysql/conf.d/
- $
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement