bigint type for ID fields in NDOUtils DB

Marc DeTrano marc at gridshield.net
Mon Mar 7 17:27:51 CET 2011


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



------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d




More information about the Developers mailing list