NDO increase nagios_servicechecks/output size

Andreas Ericsson ae at op5.se
Thu Sep 13 15:21:56 CEST 2007


Michael Streb wrote:
> Hi Ethan,
> Hi list,
> 
> recently went into problems with the "output" field in the
> nagios_servicechecks table so i had a deeper look and it turned out that the
> field size is set to "varchar(255)" only, i think this should be increased
> to something like "varchar(4096)" to make use of the longer serviceoutput in
> nagios3x.
> 
> I don`t know right now if 4k is the maximum serviceoutput in 3x.
> 

It's not, as it's dynamically allocated. 255 is the maximum size for varchar
in databases though. Anything larger than that has to be stored as "TEXT"
or "BLOB" objects, which means a fairly serious hit to performance (as all
those objects get stored in one or more separate files on disk).

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/




More information about the Developers mailing list