Page 1 of 1
update realtime table every 5 minutes (Solved)
Posted: Fri 19 Jun 2015 7:32 am
by 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?
Re: update realtime table every 5 minutes
Posted: Fri 19 Jun 2015 9:05 am
by 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.
Re: update realtime table every 5 minutes
Posted: Fri 19 Jun 2015 9:45 am
by 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
Re: update realtime table every 5 minutes
Posted: Fri 19 Jun 2015 10:18 am
by nitrx
I don't know how you can do that but please do not place passwords on the forum
Re: update realtime table every 5 minutes
Posted: Fri 19 Jun 2015 10:34 am
by kocher
Re: update realtime table every 5 minutes (Solved)
Posted: Fri 19 Jun 2015 11:47 am
by 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.
Re: update realtime table every 5 minutes (Solved)
Posted: Fri 19 Jun 2015 12:38 pm
by 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
