mirror of
https://gitlab.archlinux.org/archlinux/infrastructure.git
synced 2025-01-18 08:06:16 +01:00
6534413cf3
We used to set query_cache_type to 0 in the default settings but we were also setting query_cache_size to a non-zero/non-default value, which was in turn re-enabling the query cache. Update the configuration to reflect the actual cache state and make sure query_cache_size is set to zero for the "query_cache_type = 0" case. Now that the setting controls the real state of the query cache, disable it for bbs.archlinux.org; its hit rate is small compared to insert rate.
29 lines
908 B
YAML
29 lines
908 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
|
|
|
|
mysql_backup_dir: '/root/backup-mysql'
|
|
mysql_backup_defaults: '/root/.backup-my.cnf'
|