| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 |
- #######################
- # client #
- #######################
- [client]
- port = 3306
- socket = /var/run/mysqld/mysqld.sock
- default-character-set=utf8
- #######################
- # mysqld #
- #######################
- [mysqld]
- #
- # * Basic Settings
- #
- default-storage-engine = innodb
- #mysql_native_password = ON # disabled in v9
- #default_authentication_plugin = mysql_native_password
- user = mysql
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- datadir = /ssd
- secure-file-priv= NULL
- 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/
|
