Hi,
So I have emoncms setup and running (from an HDD) on my Raspberry Pi and it *seems* to be collecting data from my Current Cost Envi meter vi a modified version of the Perl script I found on the forum. However when I look in the MySQL emoncms database none of the tables seem to be growing, so where is the data going?
I have tables called feed_3 & feed_7, but they only contain 11 & 5 rows respectively.
What format is the date held in those tables? Is it Unix time format?
If I go to the Feeds page and press the eye icon I get a graph that seems to contain all the data I have collected over the last 7 hours or so. So where is it going?
My question is part curiosity and part wanting to be sure that I have it setup right and that the data is not just filling up the memory of my Pi.
Thanks,
David
Re: Where does emoncms store its data?
What version of emoncms are you running?
In later versions, only the data framework is stored in MYSQL, ie the things that do not readily change, whilst the actual feed data is contained in folders. Try;
/var/lib/phpfiwa
/var/lib/phpfina
/var/lib/phptimeseries
/var/lib/timestore
...but the location of the folders may be different - depending upon the emoncms version.
Paul
Re: Where does emoncms store its data?
Paul,
Thanks, for the information. I'm using the v8.3.2 of emoncms and I found the data in the folders you mentioned.
Why is data no longer stored in MySQL, performance with large datasets? MySQL now seems very heavyweight for the use it is being put to.
Thanks,
David
Re: Where does emoncms store its data?
Hi David
Checkout this thread http://openenergymonitor.org/emon/node/5319 for links to more info on the data engines and how they came about.
Paul
Re: Where does emoncms store its data?
Paul,
Thanks, that was worth reading.
David