Hi
i am new at emoncms. I create node, input and feed, and i insert values with feed id 8 and 9 and values 0 or 1 every 2 minutes. Graph and everything is working great, but i am wonderig, where are feed data saved? In PHPMyAdmin, table feeds at feed id i get update value and time (last value), but where are previous data stored? Also column size is getting bigger.
Hope you undertand my questions, thank you.
Table feeds
id name userid tag time value datatype public size engine
8 Voltage 3 Node:1 2016-01-18 09:40:32 1 1 0 6572 6
Re: Where "Feed" saving its values
Did a search not reveal the answer to this? I'm sure this question has been asked many times. If "feed saving" does not work, try "feed stored".
Re: Where "Feed" saving its values
Data is stored in MYSQL database. (user: root / pass: raspberry)
http://raspipress.com/2012/09/tutorial-install-phpmyadmin-on-your-raspbe...
Re: Where "Feed" saving its values
It depends on which storage engine is used.
Table feeds
id name userid tag time value datatype public size engine
8 Voltage 3 Node:1 2016-01-18 09:40:32 1 1 0 6572 6
Your example above references engine 6, which is phpfiwa.
phpfina, phpfiwa and phptimestore feed data are stored in /var/lib/phpfina, /var/lib/phpfiwa and /var/lib/phptimeseries respectively.
The MySQL engine stores feed data in /var/lib/mysql/emoncms.
MySQL also stores configuration data.
In addition to those, the current version of emoncms uses an engine called mysqlmemory.
(used with a virtual feed) Data are held in RAM, and lost upon shutdown or reboot.