which table store the latest data?

[fonefone]

Hi All,

I'd like to know where the latest data stored...
I'm using mysql database
can anyone help me
thanks in advance

[asaveljevs]

All the data on the server is stored in tables history, history_uint, history_log, history_str, and history_text, depending on the item type.

[zabbix_zen]

It's stored across the history* tables depending on the item's type.
To get the intended data, you need the correct itemid, clock, etc..

[alixen]

Hi,

If you are only interested in latest value, you can get it directly from items table.
There are two fields:
lastvalue varchar(255)
lastclock int(11)
that contain latest value and associated timestamp.

Regards,
Alixen

[fonefone]

i want to get free space on /home min,avg,max statistic between the past week.

i can see them from the PNG graphs below, but i can not get their value from mysql.

http://IP/zabbix/chart2.php?graphid=431&width=500&height=100&period=604800&stime=20100805141239&sid=8e56e3011cdc9907

i can get the latest data by using zabbix_get

[alixen]

Hi,

i want to get free space on /home min,avg,max statistic between the past week.

That's not latest data, the values you want are stored in trends table.
You'll have to join it with items and hosts tables to get what you want.
This is the SQL query I use for that:

select i.itemid,
       from_unixtime(clock),
       t.num,
       t.value_min,
       t.value_avg,
       t.value_max
  from hosts h,
       items i,
       trends t
 where i.hostid=h.hostid
   and t.itemid=i.itemid
   and h.host='my_host'
   and i.description='my_item'
 order by clock desc

You'll get something like:

+--------+----------------------+-----+-----------+-----------+-----------+
| itemid | from_unixtime(clock) | num | value_min | value_avg | value_max |
+--------+----------------------+-----+-----------+-----------+-----------+
|  19571 | 2010-03-31 10:00:00  |  12 |    0.6400 |    1.6033 |    3.2400 |
|  19571 | 2010-03-31 09:00:00  |  12 |    0.3700 |    1.0092 |    2.0200 |

i can see them from the PNG graphs below, but i can not get their value from mysql.

http://IP/zabbix/chart2.php?graphid=431&width=500&height=100&period=604800&stime=20100805141239&sid=8e56e3011cdc9907

This URL is not valid

i can get the latest data by using zabbix_get

I thought that you wanted to get it from the database not the device.

Regards,
Alixen

[fonefone]

Hi,



That's not latest data, the values you want are stored in trends table.
You'll have to join it with items and hosts tables to get what you want.
This is the SQL query I use for that:

select i.itemid,
       from_unixtime(clock),
       t.num,
       t.value_min,
       t.value_avg,
       t.value_max
  from hosts h,
       items i,
       trends t
 where i.hostid=h.hostid
   and t.itemid=i.itemid
   and h.host='my_host'
   and i.description='my_item'
 order by clock desc

You'll get something like:

+--------+----------------------+-----+-----------+-----------+-----------+
| itemid | from_unixtime(clock) | num | value_min | value_avg | value_max |
+--------+----------------------+-----+-----------+-----------+-----------+
|  19571 | 2010-03-31 10:00:00  |  12 |    0.6400 |    1.6033 |    3.2400 |
|  19571 | 2010-03-31 09:00:00  |  12 |    0.3700 |    1.0092 |    2.0200 |

This URL is not valid


I thought that you wanted to get it from the database not the device.

Regards,
Alixen

excellent!!!
i love you so much~~
can you tell how to write the sql by the following url:

http://zabbix.cnl.edu.cn/zabbix/charts.php?sid=f32169410a4f7062&fullscreen=0&groupid=0&hostid=0&graphid=4

need to collect one week data..