ANTID00T — /etc

editing my.cnf

#-----------------------------------------------------------------------------------------------#
#  WARNING: This file is managed by Salt, any changes will be overwritten on the next Salt run  #
#-----------------------------------------------------------------------------------------------#
#  Config designed for MariaDB 10.3/5/6                                                         #
#-----------------------------------------------------------------------------------------------#

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
performance-schema=0
port = 3306
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 = 64M
max_user_connections = 100
max_delayed_threads = 0
tmpdir = /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 = 128M
innodb_log_buffer_size = 32M
innodb_data_home_dir = /var/lib/mysql/
innodb_file_per_table = 1
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_file_size = 16M
query_cache_type = 0
query_cache_size = 0
tmp_table_size = 64M
max_heap_table_size = 64M
table_definition_cache = 8192
table_open_cache = 16384
log-error = /var/log/mysql.error.log
# log-warnings = 3

plugin-load-add=auth_socket.so
unix_socket=OFF
[mysql]
no-auto-rehash
default-character-set = utf8mb4

[mysqldump]
quick
max_allowed_packet = 32M

[isamchk]
key-buffer-size=128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key-buffer-size=128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

!include /etc/my.cnf.d/hwconf.conf

Cancel