5,838
edits
m (→MySQL settings) |
m (→MySQL settings) |
||
#With the table existing, all you need to do is:
#* Enable - tick here when you are ready for this action [using the schema (set of column names) in the SQL quoted above] to happen
#* Now move down the screen and click the '''Save''' button, and wait for MX to pop up '''Settings Saved''' message.
** The upload you select here will happen every time MX creates a new line in the monthly log file, it might be every 10 minutes, but you may have configured a different interval.
*5. ''Realtime.txt upload''
** This feature allows you to upload the file that Cumulus recreates on the most frequent basis. MX does not use the realtime.txt file in any of its supplied components, so that file by default is not available on your web server. There is an option elsewhere (Internet Settings screen) to upload this file, but an alternative is to get MX to put the values it would put into that file into a database table and this option is to do that.
#If you don't have a table in your database for this upload, first
#* Choose Table name - the default table name is "Realtime", but you can choose any other name
#*Now move down the screen and click the '''Save''' button, and wait for MX to pop up '''Settings Saved''' message
# Now find "Create database table" section below the Save button and click '''Create Realtime'''.
**# A text box where you enter a retention string in format '''retainVal=NNN retainUnit=XXXX''' where NNN is a number from 1 to 3 digits long, and XXX is a time unit e.g. second, minute, hour, day, week, month, quarter, or year.▼
#* MX will confirm when table has been created.
** Because the updates are so frequent this database table grows very quickly, and you need to say when it should delete the older rows so the table never has too many rows. If you think about it, after a few days, you probably do not need to look at this very detailed level of values information within a day. In that case set retention to delete after a few days ''retainVal=3 retainUnit=day''.▼
#With the table existing, there are 3 steps left:
# Enable - tick here when you are ready for this action [using the schema (set of column names) in the SQL quoted above] to happen automatically.
▲
▲
# Now move down the screen and click the '''Save''' button, and wait for MX to pop up '''Settings Saved''' message.
|
edits