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 :
> Michael Streb wrote:
>> Hi Ethan,
>> Hi list,
>>=20
>> 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 increas=
ed
>> to something like "varchar(4096)" to make use of the longer serviceoutpu=
t in
>> nagios3x.
>>=20
>> I don`t know right now if 4k is the maximum serviceoutput in 3x.
>>=20
>=20
> It's not, as it's dynamically allocated. 255 is the maximum size for varc=
har
> 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 al=
l
> those objects get stored in one or more separate files on disk).
--=20
Michael Streb NETWAYS GmbH
Senior Consultant Deutschherrnstr. 47a
Fon.+49 911 92885-0 D-90429 N=FCrnberg
Fax.+49 911 92885-77
[email protected] http://www.netways.de
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]