Populating emoncms mysql database with energy data

PF-Henrique · 2019-09-09T12:15:51.033Z

Hello, I want to know how do I use the emoncms mysql database structure to store consumption, energy, power, temperature data? because I don’t want data to be stored only in folders
/ var / lib / phpfiwa
/ var / lib / phpfina
/ var / lib / phptimeseries
/ var / lib / timestore

Bill.Thomson · 2019-09-09T12:27:22.744Z

This thread should help:

Emoncms, store data in mysql ! possible!? Emoncms

Hi, How i can to store my EMONCMS data in Mysql? [Sans%20titre] As you see, I always have just the latest value that changes in my database. But I want to store all the values in MySQL. Thank you for your help.

Are you aware that you’ll take a significant peformance hit with MySQL?
Performance won’t drop immediately, but rather get slower as your database grows.
If you’re not running emonCMS on a Raspberry Pi, this may not be an issue. i.e. depending on the hardware you’re running, performance may not be impacted to the same degree as it would when running emonCMS on a RasPi.

PF-Henrique · 2019-09-09T13:37:02.095Z

PF-Henrique:

/ var / lib / phpfiwa
/ var / lib / phpfina
/ var / lib / phptimeseries
/ var / lib / timestore

I want to know
How do I read the data from these files where they are currently being used for use in another application (web page)?

Robert.Wall · 2019-09-09T14:10:19.828Z

All the information you need is here: Learn→Electricity Monitoring→Timeseries

nchaveiro · 2019-09-09T17:42:43.596Z

I’v been using mysql by my own option for years.
It has grown to 20GB and no performance degradation here.
It can show a graph for a full 5 years of data as fast as one week.
The trick is how mysql engine builds the queries to ‘sample’ the data.

Bill.Thomson · 2019-09-09T23:19:27.489Z

@nchaveiro

Nuno,

What hardware are you running your “20GB database” on?