Page 1 of 1

Data size in MySQL

Posted: Thu Jul 28, 2016 6:06 am
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...

Re: Data size in MySQL

Posted: Thu Jul 28, 2016 9:47 am
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.