[prev in list] [next in list] [prev in thread] [next in thread] 

List:       nagios-devel
Subject:    Re: [Nagios-devel] NDO increase nagios_servicechecks/output size
From:       Michael Streb <mstreb () netways ! de>
Date:       2007-09-13 13:29:06
Message-ID: C30F07C2.11DD7%mstreb () netways ! de
[Download RAW message or body]

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@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@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/
_______________________________________________
Nagios-devel mailing list
Nagios-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel

[prev in list] [next in list] [prev in thread] [next in thread]