B4BY.588
Home
Terminal
Upload
information
Create File
Create Folder
About
Tools
:
/
etc
/
Filename :
my.cnf
back
Copy
#-----------------------------------------------------------------------------------------------# # WARNING: This file is managed by Salt, any changes will be overwritten on the next Salt run # #-----------------------------------------------------------------------------------------------# # Config designed for MariaDB 10.3 with separate undo table space # #-----------------------------------------------------------------------------------------------# [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 server-id = 1 socket = /var/lib/mysql/mysql.sock sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci max_allowed_packet = 512M max_connections = 1000 max_user_connections = 60 max_delayed_threads = 0 tmpdir = /var/db/mysql-tmp wait_timeout = 300 read_buffer_size = 2M read_rnd_buffer_size = 4M myisam-recover-options = DEFAULT myisam_sort_buffer_size = 128M innodb_buffer_pool_size = 8G innodb_buffer_pool_instances = 8 innodb_log_buffer_size = 256M innodb_data_home_dir = /var/lib/mysql/ innodb_file_per_table = 1 innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_file_size = 1G # innodb separate undo tablespace settings start innodb_undo_directory = /var/lib/mysql/innodb_undo innodb_undo_logs = 128 innodb_undo_tablespaces = 4 innodb_undo_log_truncate = 1 innodb_max_undo_log_size = 1024M innodb_purge_rseg_truncate_frequency = 128 # innodb separate undo tablespace settings finish query_cache_type = 0 query_cache_size = 0 query_cache_limit = 2M tmp_table_size = 512M max_heap_table_size = 512M table_definition_cache = 12000 table_open_cache = 32768 log-error = /var/log/mysql.error.log log-warnings = 3 [mysql] no-auto-rehash default-character-set = utf8mb4 [mysqldump] quick max_allowed_packet = 512M [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout