Welcome to docs.opsview.com


This shows you the differences between two versions of the page.

opsview-core:upgrading:conversiontobigintforruntimecont [2012/10/22 17:33] (current)
aburzynski created
Line 1: Line 1:
 +===== Conversion to BIGINT for two tables in Runtime =====
 +Due to a problem where the auto_increment values reached their maximum, we convert two of the columns to BIGINT, instead of INT. The two tables affected are:
 +  * nagios_hostchecks - this stores host check results
 +  * snmptrapexceptions - used for SNMP trap exceptions
 +To speed up the upgrade, the upgrade process will truncate both tables if conversion to BIGINT is needed.
 +You may want to consider altering table definition for those tables manually if you want to keep the data.
 +In any case, you may want to check that [[opsview-core:mysql#mysql_tuning|mysql]] has been tuned because we have reports that this upgrade step takes a long time if not enough memory is allocated to Mysql.