<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hallo Andreas,<br>
<br>
Hab die Berechtigungen geändert. Es läuft jetzt super durch. Dabei
werden auch Datensätze gelöscht. <br>
Wenn ich meine Datenbank-Größe ansehe (z.Zt ca. 420Mb), wird sie
jedoch nicht kleiner.<br>
Wird die "gekürzte" Datenbank in den Aggregat-Ordner eingefügt
oder werden die Datensätze wirklich gelöscht?<br>
<br>
Meine Ursprüngliche intension war, dass ich dann im Frontend auch
mal die Monatsansicht ansehen kann. <br>
Ich dachte, dass es aufgrund der Größe nicht funktioniert.<br>
Ich hab jedoch jetzt immer noch das Problem, dass ich keine
Monatsansicht ansehen kann (siehe Anhang).<br>
<br>
Oder muss ich nach dem VZCompress noch irgendwas an den
Einstellungen ändern?<br>
<br>
Danke<br>
<br>
Gruß Thomas<br>
<br>
<br>
<br>
<br>
Am 22.04.2015 um 18:30 schrieb Andreas Goetz:<br>
</div>
<blockquote
cite="mid:CAD+a8MhTmJra9Fwhj0pyRaEAJbRKMP7x0m=nheqfSUc46+k_yA@mail.gmail.com"
type="cite">
<div dir="ltr">Hallo Thomas,<br>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Apr 22, 2015 at 9:46 AM, <a
moz-do-not-send="true"
href="mailto:Heine.thomas@online.de">Heine.thomas@online.de</a>
<span dir="ltr"><<a moz-do-not-send="true"
href="mailto:Heine.thomas@online.de" target="_blank">Heine.thomas@online.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hallo,<br>
<br>
Wo und wie muss ich das machen, wenn ich es von Hand
einstellen will?<br>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Warum willst Du unbedingt den komplizierten Weg nehmen?
Warum nicht einfach den installer? Hast Du es versucht?<br>
<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div> Bin leider noch nicht all zu lange dabei und noch
in der "Lernphase"<br>
<br>
Danke für die Mühe<span class="HOEnZb"><font
color="#888888"><br>
<br>
Thomas</font></span>
<div>
<div class="h5"><br>
</div>
</div>
</div>
</div>
</blockquote>
<div>Viele Grüße,<br>
</div>
<div>Andreas<br>
<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>
<div>
<div class="h5"> <br>
<br>
Am 22.04.2015 um 09:32 schrieb Andreas Goetz:<br>
</div>
</div>
</div>
<div>
<div class="h5">
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>> string(63) "DELETE command denied
to user 'vz'@'localhost' for table 'data'"<br>
<br>
</div>
Dein vz User hat keine DELETE Rechte ->
Installationsskript nochmal laufen lassen
und die Option für die Rechte dabei
auswählen. Oder von Hand auf der DB vergeben
(Windows: z.B. MySQL Workbench).<br>
<br>
</div>
Viele Grüße,<br>
</div>
Andreas<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Apr 22, 2015 at
9:27 AM, <a moz-do-not-send="true"
href="mailto:Heine.thomas@online.de"
target="_blank">Heine.thomas@online.de</a> <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:Heine.thomas@online.de"
target="_blank">Heine.thomas@online.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hallo,<br>
<br>
Es liegen seit Anfang April etwa 4,3 Mio
Datensätze (ca.350MB) vor. <br>
Ich denkejedoch, dass noch nichts da
ist, was älter als 30 Tage ist. <br>
Aber es gibt genügend,was älter als eine
Woche ist (Reduzierung auf 1
Datensatz/sek.).<br>
<br>
hab jetzt mal folgende Reduzierung
eingertagen:<br>
<br>
(7*24*60*60) => 2, //Older than 7
Days Datapoint per 2 sekunde<br>
(30*24*60*60) => 30, //Older than 30
Days Datapoint per 30 sek<span><br>
(6*30*24*60*60) => (1*60), //Older
than 6 Month Datapoint per 1 Minutes<br>
(365*24*60*60) => (3*60), //Older
than 1 Year Datapoint per 3 Minutes<br>
<br>
<br>
</span> Hier das Ergebnis:<br>
<br>
04/22/15 09:23:52 - Processing Sensor ID
1...<br>
04/22/15 09:23:52 - Skipping
compression pass for datapoints between
03/23/15 08:23:52 and 04/15/15 09:23:52
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:52 - Skipping
compression pass for datapoints between
10/24/14 09:23:52 and 03/23/15 08:23:52
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:52 - Skipping
compression pass for datapoints between
04/22/14 09:23:52 and 10/24/14 09:23:52
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:52 - Skipping
compression pass for datapoints between
04/22/15 09:23:52 and 04/22/14 09:23:52
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:52 - Processing Sensor ID
2...<br>
04/22/15 09:23:52 - Skipping
compression pass for datapoints between
03/23/15 08:23:52 and 04/15/15 09:23:52
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:52 - Skipping
compression pass for datapoints between
10/24/14 09:23:52 and 03/23/15 08:23:52
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:52 - Skipping
compression pass for datapoints between
04/22/14 09:23:52 and 10/24/14 09:23:52
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:52 and 04/22/14 09:23:52
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
3...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
4...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
5...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
6...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
7...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
8...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
9...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
10...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
11...<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
03/23/15 08:23:53 and 04/15/15 09:23:53
using a 2 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
10/24/14 09:23:53 and 03/23/15 08:23:53
using a 30 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/14 09:23:53 and 10/24/14 09:23:53
using a 60 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Skipping
compression pass for datapoints between
04/22/15 09:23:53 and 04/22/14 09:23:53
using a 180 second timeframe: No
Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID
12...<br>
04/22/15 09:23:53 - Compressing
datapoints between 04/01/15 18:19:24 and
04/15/15 09:23:51 using a 2 second
timeframe<br>
04/22/15 09:23:53 - Processing:
04/01/15 18:19:26 - 04/01/15 18:19:28
(0%)... array(3) {<br>
[0]=><br>
string(5) "42000"<br>
[1]=><br>
int(1142)<br>
[2]=><br>
string(63) "DELETE command denied to
user 'vz'@'localhost' for table 'data'"<br>
}<br>
PHP Fatal error: SQL FAILURE in
/home/pi/<a moz-do-not-send="true"
href="http://volkszaehler.org/misc/tools/vzcompress2.php"
target="_blank">volkszaehler.org/misc/tools/vzcompress2.php</a>
on line 220<br>
<br>
Was hab ich falsch gemacht????<br>
<br>
Danke Gruß Thomas
<div>
<div><br>
<br>
<br>
Am 22.04.2015 um 08:02 schrieb
Andreas Götz:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote type="cite">
<div>In welcher Auflösung liegen
Deine Daten denn vor bzw. wieviele
Einträge pro Kanal hast Du in
welchem Zeitraum? Sieht aus als
hätte vzcompress nichts
gefunden...</div>
<div><br>
</div>
<div>Viele Grüße, Andreas <br>
<br>
<br>
</div>
<div><br>
Am 22.04.2015 um 06:58 schrieb "<a
moz-do-not-send="true"
href="mailto:Heine.thomas@online.de"
target="_blank">Heine.thomas@online.de</a>"
<<a moz-do-not-send="true"
href="mailto:Heine.thomas@online.de"
target="_blank">Heine.thomas@online.de</a>>:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div>Hallo zusammen,<br>
<br>
hab das VZCompress einmalig
durchlaufen lassen (hat etwa
17 Stunden gedauert, wie ihr
seht). Mit folgendem
Ergebniss:<br>
<br>
...<br>
...<br>
...<br>
04/22/15 06:42:16 -
Processing: 04/15/15 02:14:21
- 04/15/15 02:14:22
(100%)...
<br>
04/22/15 06:42:16 -
Processing: 04/15/15 02:14:22
- 04/15/15 02:14:23
(100%)...
<br>
04/22/15 06:42:16 -
Processing: 04/15/15 02:14:23
- 04/15/15 02:14:24
(100%)...
<br>
04/22/15 06:42:16 -
Removed 0 Datapoints in <b>16071</b>
Seconds.
<br>
04/22/15 06:42:16 - Skipping
compression pass for
datapoints between 10/24/14
02:14:25 and
<br>
03/23/15 01:14:25 using a 20
second timeframe: No
Datapoints found<br>
04/22/15 06:42:16 - Skipping
compression pass for
datapoints between 04/22/14
02:14:25 and <br>
10/24/14 02:14:25 using a 60
second timeframe: No
Datapoints found<br>
04/22/15 06:42:16 - Skipping
compression pass for
datapoints between 04/22/15
02:14:25 and <br>
04/22/14 02:14:25 using a 180
second timeframe: No
Datapoints found<br>
04/22/15 06:42:16 - Done.
Purged Datapoints from 16
Channels in <b>59200</b>
Seconds<br>
<br>
<br>
Irgendwie stimmt das aber
nicht mit meiner Configuration
überein, oder?<br>
In meinem Script steht
folgendes:<br>
<br>
<div>(7*24*60*60) => (1*1),
//Older than 7 Days
Datapoint per 1 sekunde<br>
(30*24*60*60) => (5*6),
//Older than 30 Days
Datapoint per 30 sek<br>
(6*30*24*60*60) =>
(1*60), //Older than 6 Month
Datapoint per 1 Minutes<br>
(365*24*60*60) => (3*60),
//Older than 1 Year
Datapoint per 3 Minutes<br>
<br>
wo hab ich den Fehler
gemacht?<br>
<br>
Danke Gruß Thomas<br>
</div>
<br>
<br>
<br>
Am 02.04.2015 um 10:35 schrieb
Thomas Heine:<br>
</div>
<blockquote type="cite">
<div
style="font-family:Verdana;font-size:12.0px">
<div>Hallo,</div>
<div>ich muss die Datenmenge
meines Volkszählers
verkleinern.<br>
Würde das gerne mit
vzcompress machen.<br>
Ein Messpunkt/minute ist
mir aber zu wenig.<br>
Wie soll ich das skript
abändern?</div>
<div>Ursprüngliches skript:</div>
<div>(7*24*60*60) =>
(1*60), //Older than 7
Days Datapoint per 1
Minute<br>
(30*24*60*60) =>
(5*60), //Older than 30
Days Datapoint per 5
Minutes<br>
(6*30*24*60*60) =>
(15*60), //Older than 6
Month Datapoint per 15
Minutes<br>
(365*24*60*60) =>
(30*60), //Older than 1
Year Datapoint per 30
Minutes</div>
<div><br>
Mein script:</div>
<div>(7*24*60*60) =>
(1*1), //Older than 7 Days
Datapoint per 1 sekunde<br>
(30*24*60*60) => (5*6),
//Older than 30 Days
Datapoint per 30 sek<br>
(6*30*24*60*60) =>
(1*60), //Older than 6
Month Datapoint per 1
Minutes<br>
(365*24*60*60) =>
(3*60), //Older than 1
Year Datapoint per 3
Minutes</div>
<div> </div>
<div>würde das so klappen?</div>
<div>Kann ich das skript
irgendwie einmalig
aufrufen? oder macht es
sinn, es<br>
in eine crontab zu
schreiben?</div>
<div><br>
Danke für die Hilfe!</div>
<div>Gruß</div>
<div>Thomas</div>
<div> </div>
</div>
</blockquote>
<br>
</div>
</blockquote>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</body>
</html>