1
1
mirror of https://gitlab.archlinux.org/archlinux/infrastructure.git synced 2025-01-18 08:06:16 +01:00
infrastructure/roles/mariadb/defaults/main.yml
Evangelos Foutras 743dd1faeb
borg_client: refactor database related vars/tasks
Move backup-related variable defaults from the database roles into the
borg_client role. Also check group membership to guard installation of
database backup helper scripts.
2024-03-30 19:08:37 +02:00

26 lines
822 B
YAML

mariadb_skip_name_resolve: false
mariadb_skip_networking: false
mariadb_key_buffer_size: '16M'
mariadb_max_allowed_packet: '16M'
mariadb_table_open_cache: '2000'
mariadb_sort_buffer_size: '1M'
mariadb_net_buffer_length: '8K'
mariadb_read_buffer_size: '256K'
mariadb_read_rnd_buffer_size: '512K'
mariadb_myisam_sort_buffer_size: '8M'
mariadb_query_cache_type: '1'
mariadb_query_cache_limit: '16M'
mariadb_query_cache_size: '32M'
mariadb_max_connections: '400'
mariadb_thread_cache_size: '16'
mariadb_innodb_data_file_path: 'ibdata1:10M:autoextend'
mariadb_innodb_buffer_pool_size: '128M'
mariadb_innodb_log_file_size: '96M'
mariadb_innodb_log_buffer_size: '16M'
mariadb_innodb_flush_log_at_trx_commit: '1'
mariadb_innodb_stats_sample_pages: '32'
mariadb_innodb_thread_concurrency: '8'
mariadb_innodb_file_per_table: true