Conveter feed from memory Maria db to write hdd

Emoncms
1

Hi, I already asked this question.

In my emoncms I always use mariadb for all feeds.

Given that my db is 10 years old and mostly has permanent feeds (with writing to disk), would it be possible to convert the memory-only records to the version with writing to disk?

I saw that they are created in the db but I wanted to understand what to change to make them physical.

A thousand thanks.

Michele

2

Hello @michelino

It looks like it might be possible to convert the in memory tables to persisted with SQL command:

ALTER TABLE my_memory_table ENGINE=MyISAM;

Technically it might be good to update the engine field in the emoncms feeds table and redis cache but the above might be enough on a database level

3

Perfect, done and everything works perfectly. Thank you