[client]
default-character-set = utf8
port = 3306

[wampmariadb64]
basedir = "D:/wamp/bin/mariadb/mariadb10.3.16"
datadir = "D:/wamp/bin/mariadb/mariadb10.3.16/data"
default-storage-engine = InnoDB
innodb_buffer_pool_size = 12G									;si serveur dédié 70% à 80% de la mémoire disponible
innodb_data_file_path = ibdata1:12M:autoextend
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = normal
innodb_lock_wait_timeout = 50
innodb_log_buffer_size = 512M
innodb_log_file_size = 3G										;25% de innodb_buffer_pool_size
key_buffer_size = 10M											;pour myisam seulement
lc-messages = fr_FR
lc-messages-dir = "D:/wamp/bin/mariadb/mariadb10.3.16/share"
log-error = "D:/wamp/logs/mariadb_error.log"
max_allowed_packet = 128M
myisam_sort_buffer_size = 64M
net_buffer_length = 1M											;1M est le maximum possible
port = 3306
query_cache_limit = 256M
query_cache_min_res_unit = 2k
query_cache_size = 256M
query_cache_type = 1
read_buffer_size = 8M
read_rnd_buffer_size = 64M
server-id = 1
skip-external-locking
sort_buffer_size = 16M
table_open_cache = 512
thread_cache_size = 8
wait_timeout = 120

[mysqldump]
max_allowed_packet = 128M
quick

[mysql]
default-character-set = utf8
mysql.allow_persistent = Off
no-auto-rehash
prompt = "\\U-\\v-['\\d']>"

[mysqld]
init_connect = 'SET collation_connection = utf8_unicode_ci'
init_connect = 'SET NAMES utf8'
character-set-server = utf8
collation-server = utf8_unicode_ci 
max_allowed_packet = 128M
max-connections = 50
max_heap_table_size = 64M
port = 3306
skip-name-resolve
tmp_table_size = 64M