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 [email protected]
OP5 AB www.op5.se
Tel: +46 8-230225 Fax: +46 8-230231
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]