The commit was missing after the MySQL queries, leaving e.g. updated
V2 Hoods unchanged in the database.
Add commit for individual function and for the script to be sure
nothing else is overlooked.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
Polyhoods need to be read manually. Running
scripts/readpolyhoods.py will erase both tables and reread data.
At the moment, the URL points to a test setup.
This requires changes to the MySQL database!
This is meant for later use and does NOT add any data to the
Monitoring at the moment.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This obsoletes the hood initialization file.
Hood are capitalized and "V1" is added at the end.
This may require a rename of the existing hood stats.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
scripts/defragtables.py:
- If run without argument, all tables EXCEPT stats are defragmented
(quick run)
- If run with argument e.g. "1", all table INCLUDING stats are
defragmented (will take about one hour)
scripts/defragtable.py <space-separated list of tables>:
- Defragments the specified tables; will crash if table does not
exist
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This add Gateway stats which work similar to the detailed hood
statistics.
This requires changes to the MySQL database!
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
This patch enables committing after each statement of the old
data deletion. Maybe this helps to prevent a big single locking
period.
In addition, the duration is shown for individual steps.
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>