How to add logger tables

Revision as of 12:40, 1 October 2019 by Teodor Vizirov (talk | contribs) (Created page with "=How to add logger tables= {{KB|{{ZC}}|{{ZCS 8.8}}|{{ZCS 8.7}}||}} {{WIP}} ==Problem== Zimbra includes the logger service, that collects data from different servers for the...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

How to add logger tables

   KB 23882        Last updated on 2019-10-1  




0.00
(0 votes)


Problem

Zimbra includes the logger service, that collects data from different servers for the state of the different services. If multiserver installation is in place, there must be only one logger server, and the rest of the server are viewed as clients. Each client and the logger server keep a database for the known servers in the setup, placed in SQLite3 database.

Resolution

1. Enter mysql command line:

$ mysql

2. Once inside confirm the current setting:

show variables like "max_connections";

3. Change the current setting with higher value:

set global max_connections = 200;

4. Restart:

$ mysql.server stop 
$ mysql.server start 

However after server restart these settings will be gone.

To make the change permanent:

1. Edit my.cnf file and under [mysqld] section change the max_connections value.

2. Restart:

$ mysql.server stop 
$ mysql.server start 


IMPORTANT: Increasing the connections will also increase the memory usage on the server. Make sure you have enough resources before applying these changes.


Verified Against: Zimbra Collaboration 8.7, 8.8.9, 8.8.12 Date Created: 7/10/2019
Article ID: https://wiki.zimbra.com/index.php?title=How_to_add_logger_tables Date Modified: 2019-10-01



Try Zimbra

Try Zimbra Collaboration with a 60-day free trial.
Get it now »

Want to get involved?

You can contribute in the Community, Wiki, Code, or development of Zimlets.
Find out more. »

Looking for a Video?

Visit our YouTube channel to get the latest webinars, technology news, product overviews, and so much more.
Go to the YouTube channel »


Wiki/KB reviewed by SME1 SME2 COPY EDITOR Last edit by Teodor Vizirov
Jump to: navigation, search