Bug 40216

Summary: Adjust mysql default configuration
Product: UCS Reporter: Stefan Gohmann <gohmann>
Component: MySQLAssignee: Erik Damrose <damrose>
Status: CLOSED FIXED QA Contact: Janek Walkenhorst <walkenhorst>
Severity: enhancement    
Priority: P5 CC: damrose, gohmann, gulden, schwardt
Version: UCS 4.1   
Target Milestone: UCS 4.1-2-errata   
Hardware: Other   
OS: Linux   
What kind of report is it?: --- What type of bug is this?: ---
Who will be affected by this bug?: --- How will those affected feel about the bug?: ---
User Pain: Enterprise Customer affected?:
School Customer affected?: ISV affected?:
Waiting Support: Flags outvoted (downgraded) after PO Review:
Ticket number: Bug group (optional): Roadmap discussion (moved), Usability
Max CVSS v3 score:
Bug Depends on:    
Bug Blocks: 39471    

Description Stefan Gohmann univentionstaff 2015-12-10 17:42:04 CET 
As discussed, we should deliver a default configuration which matches the requirements of Zarafa, OX and other Apps we have in our App Center which uses MySQL.


+++ This bug was initially created as a clone of Bug #39471 +++

UCS offers no ucr template for the mysql config. A partner requested this feature for an App. Several Apps use mysql in their backend.
Comment 1 Stefan Gohmann univentionstaff 2015-12-10 17:45:00 CET 
@Erik, please check the Zarafa requirements

@Sönke, maybe you can check the OX requirements.
Comment 2 Erik Damrose univentionstaff 2016-06-21 16:07:25 CEST 
The following values are configured based on feedback:

max_connections?151
max_allowed_packet?33554432
query_cache_size?33554432
query_cache_limit?2097152
innodb_buffer_pool_size?157286400

Some values are set to their default values, only to have them available preconfigured via UCR to allow easy searching and modification for end users.

QA: Check which values mysqld will load with 'mysqld --verbose --help'

r70500 univention-mysql 3.0.0-2.17.201606211557
r70501 yaml
Comment 3 Janek Walkenhorst univentionstaff 2016-07-22 16:08:13 CEST 
Tests: OK
Advisory: OK
Comment 4 Janek Walkenhorst univentionstaff 2016-08-03 15:56:35 CEST 
<http://errata.software-univention.de/ucs/4.1/223.html>