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.
66 lines
1.9 KiB
Django/Jinja
66 lines
1.9 KiB
Django/Jinja
[client]
|
|
port = 3306
|
|
socket = /run/mysqld/mysqld.sock
|
|
|
|
[mysqld]
|
|
bind_address = localhost
|
|
port = 3306
|
|
socket = /run/mysqld/mysqld.sock
|
|
skip-external-locking
|
|
{% if mariadb_skip_name_resolve %}
|
|
skip-name-resolve
|
|
{% endif %}
|
|
{% if mariadb_skip_networking %}
|
|
skip-networking
|
|
{% endif %}
|
|
|
|
# Memory settings
|
|
key_buffer_size = {{ mariadb_key_buffer_size }}
|
|
max_allowed_packet = {{ mariadb_max_allowed_packet }}
|
|
table_open_cache = {{ mariadb_table_open_cache }}
|
|
sort_buffer_size = {{ mariadb_sort_buffer_size }}
|
|
net_buffer_length = {{ mariadb_net_buffer_length }}
|
|
read_buffer_size = {{ mariadb_read_buffer_size }}
|
|
read_rnd_buffer_size = {{ mariadb_read_rnd_buffer_size }}
|
|
myisam_sort_buffer_size = {{ mariadb_myisam_sort_buffer_size }}
|
|
max_connections = {{ mariadb_max_connections }}
|
|
thread_cache_size = {{ mariadb_thread_cache_size }}
|
|
userstat = 1
|
|
|
|
# Query cache settings
|
|
query_cache_type = {{ mariadb_query_cache_type }}
|
|
query_cache_limit = {{ mariadb_query_cache_limit }}
|
|
{% if mariadb_query_cache_type == '0' %}
|
|
query_cache_size = 0
|
|
{% else %}
|
|
query_cache_size = {{ mariadb_query_cache_size }}
|
|
{% endif %}
|
|
|
|
# Single server setup
|
|
server-id = 1
|
|
|
|
# InnoDB settings
|
|
innodb_data_file_path = {{ mariadb_innodb_data_file_path }}
|
|
innodb_buffer_pool_size = {{ mariadb_innodb_buffer_pool_size }}
|
|
innodb_log_file_size = {{ mariadb_innodb_log_file_size }}
|
|
innodb_log_buffer_size = {{ mariadb_innodb_log_buffer_size }}
|
|
innodb_flush_log_at_trx_commit = {{ mariadb_innodb_flush_log_at_trx_commit }}
|
|
innodb_stats_sample_pages = {{ mariadb_innodb_stats_sample_pages }}
|
|
innodb_thread_concurrency = {{ mariadb_innodb_thread_concurrency }}
|
|
{% if mariadb_innodb_file_per_table %}
|
|
innodb_file_per_table
|
|
{% endif %}
|
|
|
|
[mysqldump]
|
|
quick
|
|
max_allowed_packet = 16M
|
|
|
|
[myisamchk]
|
|
key_buffer_size = 20M
|
|
sort_buffer_size = 20M
|
|
read_buffer = 2M
|
|
write_buffer = 2M
|
|
|
|
[mysqlhotcopy]
|
|
interactive-timeout
|