[Nagios-devel] bigint type for ID fields in NDOUtils DB
Posted: Mon Mar 07, 2011 5:28 pm
I'd like to suggest that the DB creation script for NDOUtils set as type
"BIGINT" the servicecheck_id auto-increment field of the
nagios_servicechecks table...and possibly use bigint for some other
tables that may exceed the 2-billion value limit for a signed int
(statehistory, log entries, etc). MySQL starts to complain when an
auto-increment field tries to exceed the max-value for the field and
stops allowing further entries to the table.
Marc DeTrano
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]
"BIGINT" the servicecheck_id auto-increment field of the
nagios_servicechecks table...and possibly use bigint for some other
tables that may exceed the 2-billion value limit for a signed int
(statehistory, log entries, etc). MySQL starts to complain when an
auto-increment field tries to exceed the max-value for the field and
stops allowing further entries to the table.
Marc DeTrano
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]