Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.0.1 (build 4023) - 16 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V4 release 4.0.1 (build 4023) - 16 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
MySQL Monthly Table
-
- Posts: 8
- Joined: Wed 02 Mar 2016 7:37 pm
- Weather Station: LaCrosse WS2300, Oregon WMR88/89
- Operating System: Windows Server 2012 R2
- Location: UK
- Contact:
MySQL Monthly Table
Hi, I have a question about the SQL Monthly table. I currently have my station reporting every 5 mins and this is then logged into a monthly table on my MySQL Server however I would like to know what happened when the month is over. Is a new table created?
-
- Posts: 8
- Joined: Wed 02 Mar 2016 7:37 pm
- Weather Station: LaCrosse WS2300, Oregon WMR88/89
- Operating System: Windows Server 2012 R2
- Location: UK
- Contact:
Re: MySQL Monthly Table
So what is the difference between the monthly and daily table?
Could I suggest this to be a feature in a later version? Table for each month.
Could I suggest this to be a feature in a later version? Table for each month.
Last edited by wbargent on Thu 03 Mar 2016 9:23 pm, edited 1 time in total.
Re: MySQL Monthly Table
Why?wbargent wrote: Could I suggest this to me a feature in a later version? Table for each month.
- philpugh
- Posts: 393
- Joined: Tue 24 May 2011 8:34 am
- Weather Station: See Signature
- Operating System: Debian 11 (RPi4)
- Location: Antrobus, Cheshire, UK
- Contact:
Re: MySQL Monthly Table
You will find that it is much easier to do analysis/summary work on the whole table. That said I also make a copy of the data into yearly tables.
Phil Pugh
GW1100 + WH65/WH57/WH31;GW1100 + WS68/WH40A (also with HP25xx console); GW2001 WittBoy
CumulusMX V4 / CUtils V7
Raspberry Pi 5 64bit
https://goosegate.uk/
GW1100 + WH65/WH57/WH31;GW1100 + WS68/WH40A (also with HP25xx console); GW2001 WittBoy
CumulusMX V4 / CUtils V7
Raspberry Pi 5 64bit
https://goosegate.uk/
- steve
- Cumulus Author
- Posts: 26701
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: MySQL Monthly Table
The monthly table contains the minute-by-minute data corresponding to the monthly log files in MX (Mar16log.txt etc), and the daily table contains the daily summary data corresponding to the dayfile.txt file.wbargent wrote:So what is the difference between the monthly and daily table?
It's all in one table to make queries easier. MX will use the table itself at some point, so I won't be changing that. It's possible there might eventually be an option to create an additional table for each month, but I'm not sure of the benefits.Could I suggest this to be a feature in a later version? Table for each month.
Steve
- mcrossley
- Posts: 12886
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: MySQL Monthly Table
I can't see any possible benefits either. Splitting the data into tables would make handling it much more difficult in most instances.
If you really wanted to see month by month data without adding a where clause, then you could always create a view for each month.
If you really wanted to see month by month data without adding a where clause, then you could always create a view for each month.
-
- Posts: 8
- Joined: Wed 02 Mar 2016 7:37 pm
- Weather Station: LaCrosse WS2300, Oregon WMR88/89
- Operating System: Windows Server 2012 R2
- Location: UK
- Contact:
Re: MySQL Monthly Table
The main reason my I wan't to do this was due to the number of records that get inserted into my table; 1 every 5 mins. I thought it would be a good way to split the data up into smaller tables (not that they will they will be small) making them more manageable and easier to locate records using an application like phpmyadmin or Toad.
- mcrossley
- Posts: 12886
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: MySQL Monthly Table
The table is indexed on the date/time by default, so even with millions of records retrieving the date range you want should be fast.
My table only goes back to Jan 2010 with approx 500,000 rows, extracting the records for Jan 2016...
(8922 total, Query took 0.0023 sec)
My table only goes back to Jan 2010 with approx 500,000 rows, extracting the records for Jan 2016...
(8922 total, Query took 0.0023 sec)