| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 |
- #######################
- # client #
- #######################
- [client]
- port = 3306
- socket = /var/run/mysqld/mysqld.sock
- #######################
- # mysqld #
- #######################
- [mysqld]
- #
- # * Basic Settings
- #
- default-storage-engine = innodb
- default_authentication_plugin = mysql_native_password
- user = mysql
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- port = 3306
- skip-external-locking
- skip-name-resolve
- lower_case_table_names = 1
- character-set-server=utf8
- collation-server=utf8_general_ci
- #
- # * Fine Tuning
- #
- key_buffer_size = 16M
- max_allowed_packet = 16M
- thread_stack = 256K
- thread_cache_size = 128
- max_connections = 5000
- back_log = 5000
- table_open_cache = 800
- table_definition_cache = 800
- max_heap_table_size = 128M
- tmp_table_size = 128M
- #
- # monitoring off
- #
- performance-schema = false
- #
- # innodb settings
- #
- innodb_use_native_aio = 1
- # sync for every sec. not for every commit.
- innodb_flush_log_at_trx_commit = 2
- innodb_flush_method=O_DIRECT
- innodb_buffer_pool_instances=14
- sync_binlog=0
- #
- # * Query Cache Configuration
- max_prepared_stmt_count = 1048576
- #######################
- # mysqldump #
- #######################
- [mysqldump]
- quick
- quote-names
- max_allowed_packet = 16M
- !includedir /etc/mysql/conf.d/
|
