update realtime table every 5 minutes (Solved)

[kocher]

CumulusMX works well.

I still have some details to improve:

MySQL:

The table "realtime" is updated every 5 seconds, but I'd like to do it every 5 minutes.
How I can get it?

[steve]

It's updated at the realtime interval that you have configured, so if you want realtime updates of 5 minutes, change that setting. Or use a 'custom' MySQL update.

[kocher]

Thanks for your help Steve

MYSQL I'm trying to customize the "Custom.inf" file:

Code: Select all

[MySQL][/b]
Host = xx
Port = 3306
User = xx
Pass = xx
Database = xx
MonthlyMySqlEnabled = 1
RealtimeMySqlEnabled = 0
DayfileMySqlEnabled = 1
MonthlyTable = monthly
DayfileTable = dayfile
RealtimeTable = realtime
RealtimeRetention =
CustomMySqlSecondsCommandString =
CustomMySqlMinutesCommandString =
CustomMySqlRolloverCommandString =
CustomMySqlSecondsEnabled = 0
CustomMySqlMinutesEnabled = 0
CustomMySqlRolloverEnabled = 0
CustomMySqlSecondsInterval = 300
CustomMySqlMinutesIntervalIndex = 4

What values have to put in CustomMYSql to actualize it every 5 minutes?

[nitrx]

I don't know how you can do that but please do not place passwords on the forum

[kocher]

[steve]

I don't know what the Custom.inf file is, but if you want to create a custom MySQL upload at an interval of 5 minutes, you should use the "Custom upload - minutes interval" section on the MySQL page in the MX user interface. See the post where I announced the facility for more information.

[kocher]

Hi Steve

The problem I had was that when setting up the "Realtime Interval" I thought the value was referring to minutes ...

Once I've set to the value 300, it has solved the problem.

Greetings and thank you very much for help


Javier