5,838
edits
Category:Cumulus MX: Difference between revisions
m
→MySQL settings
m (→MySQL settings) |
m (→MySQL settings) |
||
| Line 758: | Line 758: | ||
#With the table existing, all you need to do is: | #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 | #* 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. | #* 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. | ** 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. | ||
| Line 774: | Line 774: | ||
*5. ''Realtime.txt upload'' | *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. | ** 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'''. | |||
#* MX will confirm when table has been created. | |||
#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. | |||
# 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. | |||
#* 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''. | |||
# Now move down the screen and click the '''Save''' button, and wait for MX to pop up '''Settings Saved''' message. | |||