Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Sign in
  • infrastructure infrastructure
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Issues 108
    • Issues 108
    • List
    • Boards
    • Service Desk
    • Milestones
    • Iterations
  • Merge requests 20
    • Merge requests 20
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
    • Test Cases
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Code review
    • Insights
    • Issue
    • Repository
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Arch LinuxArch Linux
  • infrastructureinfrastructure
  • Merge requests
  • !79

Improve mariadb configuration

  • Review changes

  • Download
  • Email patches
  • Plain diff
Merged Jakub Klinkovský requested to merge lahwaacz/infrastructure:mariadb-defaults into master Sep 05, 2020
  • Overview 4
  • Commits 2
  • Pipelines 4
  • Changes 7
  • Our mariadb_table_open_cache was too low (64 in the defaults and 256 in the playbooks), bumbed to the upstream default (2000).
  • The playbooks set innodb_buffer_pool_size to 64M, but the default was bumped to 128M in f164d000 so the playbooks should be likely updated too. Which value should we use? Generally, higher is better (depending on the amount of available RAM): see documentation.
  • The playbooks set query_cache_type to 0 (i.e. OFF), but this is not enough to disable the query cache - setting query_cache_size to 0 is necessary! See the warning in the Mariadb documentation. I assume the query cache should be disabled, since it is explicitly deprecated in MySQL and Mariadb has many warnings about it too. Should I disable it in all playbooks?

CC @grazzolini @jelle @svenstaro

Edited Sep 05, 2020 by Jakub Klinkovský
Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: mariadb-defaults