Bug 40216 – Adjust mysql default configuration

Bug 40216 - Adjust mysql default configuration


Summary:	Adjust mysql default configuration

Status:	CLOSED FIXED

Product:	UCS
Classification:	Unclassified
Component:	MySQL
Version:	UCS 4.1
Hardware:	Other Linux

Importance:	P5 enhancement (vote)
Target Milestone:	UCS 4.1-2-errata
Assigned To:	Erik Damrose
QA Contact:	Janek Walkenhorst

URL:
Keywords:

Depends on:
Blocks:	39471
	Show dependency tree / graph

Reported:	2015-12-10 17:42 CET by Stefan Gohmann
Modified:	2016-08-03 15:56 CEST (History)
CC List:	4 users (show)

See Also:
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:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Stefan Gohmann

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

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

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

2016-07-22 16:08:13 CEST

Tests: OK
Advisory: OK

Comment 4 Janek Walkenhorst

2016-08-03 15:56:35 CEST

<http://errata.software-univention.de/ucs/4.1/223.html>