NDO increase nagios_servicechecks/output size

[Michael Streb]

Hi,

Out of the mysql docs:

Values in VARCHAR columns are variable-length strings. The length can be
specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in
5.0.3 and later versions. (The maximum effective length of a VARCHAR in
MySQL 5.0.3 and later is determined by the maximum row size and the
character set used. The maximum column length is subject to a row size of
65,535 bytes, which is shared among all columns.)

Regards,

Michael


Am 13.09.2007 15:21 Uhr schrieb "Andreas Ericsson" unter <ae at op5.se>:

> 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).

-- 
Michael Streb                 NETWAYS GmbH
Senior Consultant             Deutschherrnstr. 47a
Fon.+49 911 92885-0           D-90429 Nürnberg
Fax.+49 911 92885-77
mstreb at netways.de             http://www.netways.de


-------------------------------------------------------------------------
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/