Data size in MySQL

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
rajiv30299
Posts: 9
Joined: Mon Jul 18, 2016 4:12 am

Data size in MySQL

Post by rajiv30299 »

Hi All,

Can we someone answer this crazy question shoot by one of our client..

How much size data stores in MySQL DB by 1 host in 1 day ?

If its 1:10 is the host:service ratios.

How can we know such details...
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Data size in MySQL

Post by tmcdonald »

This is dependent on many factors, such as the frequency of the checks, the database retention settings, the type/output of the check, etc. Even with these variables known, we do not have any sizing information that would apply very well as a general statement. Our advice is always to test in a development environment, determine a baseline, and extrapolate from there. This will give you results that are more fitting to your setup.
Former Nagios employee
Locked