Cacti: Unterschied zwischen den Versionen

Aus Xinux Wiki
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „=Install= ==Prerequisites== *sudo apt update ==Install Apache & MariaDB== *sudo apt install -y apache2 mariadb-server mariadb-client php-mysql libapache2-mod-p…“)
 
Zeile 8: Zeile 8:
 
==Install Snmp==
 
==Install Snmp==
 
*sudo apt install -y snmp php-snmp rrdtool librrds-perl
 
*sudo apt install -y snmp php-snmp rrdtool librrds-perl
 +
=Configuration=
 +
==Database Tuning==
 +
*vi /etc/mysql/mariadb.conf.d/50-server.cnf
 +
<pre>
 +
collation-server = utf8mb4_unicode_ci
 +
max_heap_table_size = 128M
 +
tmp_table_size = 64M
 +
join_buffer_size = 64M
 +
innodb_file_format = Barracuda
 +
innodb_large_prefix = 1
 +
innodb_buffer_pool_size = 512M
 +
innodb_flush_log_at_timeout = 3
 +
innodb_read_io_threads = 32
 +
innodb_write_io_threads = 16
 +
innodb_io_capacity = 5000
 +
innodb_io_capacity_max = 10000
 +
</pre>

Version vom 10. Februar 2020, 14:15 Uhr

Install

Prerequisites

  • sudo apt update

Install Apache & MariaDB

  • sudo apt install -y apache2 mariadb-server mariadb-client php-mysql libapache2-mod-php

Install PHP Extensions

  • sudo apt install -y php-xml php-ldap php-mbstring php-gd php-gmp

Install Snmp

  • sudo apt install -y snmp php-snmp rrdtool librrds-perl

Configuration

Database Tuning

  • vi /etc/mysql/mariadb.conf.d/50-server.cnf
collation-server = utf8mb4_unicode_ci
max_heap_table_size = 128M
tmp_table_size = 64M
join_buffer_size = 64M
innodb_file_format = Barracuda
innodb_large_prefix = 1
innodb_buffer_pool_size = 512M
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16
innodb_io_capacity = 5000
innodb_io_capacity_max = 10000