Make the setup production-ready, adjust resource allocation and optimize stuff if needed

Sysadmin work

Budgeted time: 16h

Suggestions:

• Give the VM one more vCPU? Sometimes the webapp (run within the apache process) and mysqld are competing for resources and there are timeouts in the web UI.
• Optimize MariaDB config according to the size and usage of our database? Sometimes MariaDB is eating a full CPU core for a long time, while there’s quite some free RAM. Presumably bigger caches etc. might help.

Parent Task: #10034 (closed)

Subtasks

• #12220 (closed)
• #15359 (closed)
• #16135 (closed)
• #16450 (closed)
• #16525 (closed)

Original created by @u on 16436 (Redmine)