Re: [Perfparse-users] Data in Database

[Ben C. <bcl...@pe...>]

The storage format is 'FLOAT'.  I don't know why your data is being 
stored as integers.  I would need to see the SQL used.  This can be 
obtained simply from the logs using 'mysqlbinlog'.

Something a but like like:

mysqlbinlog yyyyyy.xxxxxx | grep -i "INSERT" | grep 
"perfdata_service_bin" | grep "Ping"

Where yyyyy is your machine name and xxxxxx is the largest log file 
number.  Eg, /usr/local/mysql/var/nagios.0000123

This should produce the SQL statements used to enter your data.  I would 
be very interested in seeing these.

I have a feeling we may see:  INSERT ... VALUES ( '0,25'
And not the required:         INSERT ... VALUES ( '0.25'

--------------------

Another way of viewing the amount of data in the database is using:

mysql> SHOW TABLE STATUS\G

This gives estimated values.  But they are usually good.

(Would any member be interested in writing a quick HTML report of this 
data?)

If you want to limit your data, look at the Deletion Policies.

--------------------

I hope this is of some use,

Ben.




Yves wrote:
>>I use the plugin check_icmp
>>which output look like this:
>>
>>nagios@rzvlabwks:/usr/local/nagor/nagios/libexec> ./check_icmp -H jholle
>>OK - jholle: rta 0.25 ms, lost 0%|rta=0.25ms;200;500;; pl=0%;60;80;;
>>
>>it's ok.
>>But the Database look so:
>>
>>42684 | jholle    | Ping                | rta    | 2005-02-28 08:38:29 |
>>0 |   200 |      500 |     0 |
>>| 42685 | jholle    | Ping                | pl     | 2005-02-28 08:38:29 |
>>  0 |    40 |       80 |     0 |
>>
>>So for the time is always a 0 value. Is this a known problem or what do I
>>wrong?
> 
> 
> 
> Anybody to help ?
> Anybody who can check if this can be the storage format of the database that does not
> allow float values ?
> 
> 
>>Another question is how many data is stored into my database. Is it defined
>>how many data is stored? When yes where?
> 
> 
> This is not defined anywhere.
> However, you can use SQL requests like this:
> select count(*) from perfdata_host
> select count(*) from perfdata_service_bin
> select count(*) from perfdata_service_metric
> ... and so on
> 
> Yves
>