Table data overflows

If you are trying to store numbers bigger than what tagente_datos can hold, you can increase its precision by connecting to Pandora FMS’ database and issuing the following command:

ALTER TABLE tagente_datos MODIFY datos double(precision, 2) default NULL;

For example, if you need to store 128 bit integers (which go up to 3.4e38) you need 39 digits for the integer part. Since Pandora FMS uses 2 digits for the fractional part, the resulting command would be:

ALTER TABLE tagente_datos MODIFY datos double(41, 2) default NULL;
Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support