Modul 93_DbRep - Reporting und Management von Datenbankinhalten (DbLog)

DS_Starter · 31 März 2017, 11:33:53

Hallo,

ich habe die Version 4.12. im Eingangsbeitrag hinterlegt.
Hinzugekommen ist die Unterstützung für primary key in den insert-Funktionen insert bzw. importFromFile.
Damit sind diese Funktionen kompatibel zu DbLog sofern man einen primary key in der Tabelle history setzt.

viele Grüße
Heiko

Omega · 03 April 2017, 22:23:24

Eine Frage zur Ermittlung der DB-Größe:

In der Console kann ich mit folgender Anweisung

Code Auswählen

mysql -u root -pPasswort -e 'select table_schema "Database",round(sum(data_length+index_length)/1024/1024,4) "Size (MB)" from information_schema.tables group by table_schema;'

die Größe der kompletten DB sehen (momentan 243,9 MB) . Ich weiß, dass die Tabelle history unwesentlich kleiner ist.
Mit dem Tool HeidiSQL kann ich auch die DB- bzw. Tabellen-Größe sehen, aktuell 243,9 MB.

Ermittle ich die DB-Größe, wie im Wiki zu DbRep beschrieben, erhalte ich in INFO_history.data_index_lenth_MB den Wert 332.89 MB. Das ist ja doch eine ziemliche Abweichung, die ich nicht verstehe.

Was muss ich zur Ermittlung der DB-Größe noch beachten?

LG
Holger

DS_Starter · 03 April 2017, 22:50:43

Hi Holger,

ZitatWas muss ich zur Ermittlung der DB-Größe noch beachten?

Nichts weiter.
Ich habe natürlich gleich bei mir das gleiche ausgeführt. Die Größe lasse ich vom Modul für einen Plot regelmäßig ermitteln. Jetzt habe ich es sowohl in phpMyadmin als auch von der Konsole wie du ausgeführt und bekomme in allen Fällen die gleichen Ergebnisse wie mit DbRep (bis auf Nachkommastellen).
In DbRep wird übrigens derselbe Aufruf zur Ermittlung verwendet.

Hmm ... da kann ich Addhoc keine Erkärung für diese Abweichung finden.

Du kannst mit verbose 5 ein "get tableinfo" fahren. Es gibt dann im Log am Ende einen Eintrag "-> row_array: " mit den Rohdaten nach der Abfrage.
Vllt. sieht man dann etwas mehr.

LG
Heiko

Omega · 04 April 2017, 10:07:11

Hallo Heiko,

leider ist es noch etwas komplizierter. Ich habe derzeit 2 mySQL-DBs (myFHEMdb und myFHEMdb_LT).
Nach Miternacht setze ich bei beiden DBs ein ,,set ... countEntries" und ein ,,get ... tableinfo" ab. Die Anzahl der Records ist annähernd identisch mit dem Tool HeidiSQL (myFHEMdb = 1172043, myFHEMdb_LT = 512601 Records). Die DB-Größe wird aber bei beiden DBs identisch (und falsch) angegeben mit jetzt 336.89 MB. Bei der unterschiedlichen Satzanzahl unrealistisch.

Hier ein Auszug von "get tableinfo" mit verbose 5
myFHEMdb:

Code Auswählen


2017.04.04 09:29:05 5: DbRep rep.myFHEMdb.Size -> row_array: 
current.table_schema fhem current.data_index_length_MB 0.23 current.table_name fhem current.data_free_MB 4.00 current.row_format Compact current.table_collation utf8_bin current.engine InnoDB current.table_type BASE_TABLE current.create_time 2017-03-23_00:09:28 history.table_schema fhem history.data_index_length_MB 336.89 history.table_name fhem history.data_free_MB 4.00 history.row_format Compact history.table_collation utf8_bin history.engine InnoDB history.table_type BASE_TABLE history.create_time 2017-03-23_00:09:28

und myFHEMdb_LT:

Code Auswählen


2017.04.04 09:28:47 5: DbRep rep.myFHEMdb_LT.Size -> row_array: 
current.table_schema fhem current.data_index_length_MB 0.23 current.table_name fhem current.data_free_MB 4.00 current.row_format Compact current.table_collation utf8_bin current.engine InnoDB current.table_type BASE_TABLE current.create_time 2017-03-23_00:09:28 history.table_schema fhem history.data_index_length_MB 336.89 history.table_name fhem history.data_free_MB 4.00 history.row_format Compact history.table_collation utf8_bin history.engine InnoDB history.table_type BASE_TABLE history.create_time 2017-03-23_00:09:28

Hier fallen mir identische ,,...create_time" Einträge auf. Für die DB myFHEMdb_LT ist das aber falsch. Hier müsste 2017-03-22_23:43:49 stehen. Wird die falsche DB gelesen? In der Ergebniszeile (row_array) würde ich bei myFHEMdb_LT erwarten, dass da "current.table_schema fhem_lt" steht und nicht "current.table_schema fhem". Macht vielleicht der "_" im Namen Probleme?
Irgendwo ist ein Wurm darin...

Übersicht über meine Definitionen:
myFHEMdb:

Code Auswählen


Internals: 
   COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32 
   CONFIGURATION /opt/fhem/dblog/sqldb.conf 
   DBMODEL    MYSQL 
   DEF        /opt/fhem/dblog/sqldb.conf .*:.* 
   MODE       asynchronous 
   NAME       myFHEMdb 
   NR         229 
   NTFY_ORDER 50-myFHEMdb 
   PID        4224 
   REGEXP     .*:.* 
   STATE      connected 
   TYPE       DbLog 
   VERSION    2.14.4 
   dbconn     mysql:database=fhem;host=192.168.0.25;port=3306 
   dbuser     fhem 
   Helper: 
     COLSET     1 
     DEVICECOL  64 
     EVENTCOL   512 
     READINGCOL 64 
     TYPECOL    64 
     UNITCOL    32 
     VALUECOL   128 
   Helper: 
     Dblog: 
       Countcurrent: 
         Mydblog: 
           TIME       1491291632.33305 
           VALUE      1535 
         Myfhemdb: 
           TIME       1491291632.3382 
           VALUE      1535 
       Counthistory: 
         Mydblog: 
           TIME       1491291632.32342 
           VALUE      1172753 
         Myfhemdb: 
           TIME       1491291632.32741 
           VALUE      1172753 
       Lastrowsdeleted: 
         Mydblog: 
           TIME       1491256863.41192 
           VALUE      0 
         Myfhemdb: 
           TIME       1491256863.41605 
           VALUE      0 
       State: 
         Mydblog: 
           TIME       1491291632.01284 
           VALUE      countNbl 
         Myfhemdb: 
           TIME       1491291632.01807 
           VALUE      countNbl 
   Readings: 
     2017-04-04 09:41:08   CacheUsage      18 
     2017-04-04 09:41:08   NextSync        2017-04-04 09:41:38 or if CacheUsage 500 reached 
     2017-04-04 09:40:32   countCurrent    1535 
     2017-04-04 09:40:32   countHistory    1172753 
     2017-04-04 00:01:03   lastRowsDeleted 0 
     2017-04-04 09:41:08   state           connected 
   Cache: 
     index      109712 
     Memcache: 
       109695     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed: 152626|electricityConsumed|152626| 
       109696     2017-04-04 09:41:08|strombezug|JSONMETER|statElectricityConsumed: Hour: 571 Day: 4710 Month: 33746 Year: 33746 (since: 2017-04-02 )|statElectricityConsumed|Hour: 571 Day: 4710 Month: 33746 Year: 33746 (since: 2017-04-02 )| 
       109697     2017-04-04 09:41:08|strombezug|JSONMETER|statElectricityConsumedToday: 4710|statElectricityConsumedToday|4710| 
       109698     2017-04-04 09:41:08|strombezug|JSONMETER|electricityPower: 657|electricityPower|657| 
       109699     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_kWh: 152.626|electricityConsumed_kWh|152.626| 
       109700     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumedToday_kWh: 4.71|electricityConsumedToday_kWh|4.71| 
       109701     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_PowerCurrent: 654.545|electricityConsumed_PowerCurrent|654.545| 
       109702     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_PowerDayAver: 486.392|electricityConsumed_PowerDayAver|486.392| 
       109703     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyDay: 4.710|electricityConsumed_EnergyDay|4.710| 
       109704     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyMonth: -4887.374|electricityConsumed_EnergyMonth|-4887.374| 
       109705     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyYear: -4887.374|electricityConsumed_EnergyYear|-4887.374| 
       109706     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyMeter: -4887.374|electricityConsumed_EnergyMeter|-4887.374| 
       109707     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyCostDay: 1.201|electricityConsumed_EnergyCostDay|1.201| 
       109708     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyCostMonth: -1246.280|electricityConsumed_EnergyCostMonth|-1246.280| 
       109709     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyCostYear: -1246.280|electricityConsumed_EnergyCostYear|-1246.280| 
       109710     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_EnergyCostMeter: -1246.280|electricityConsumed_EnergyCostMeter|-1246.280| 
       109711     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_FinanceReserve: 2796.730|electricityConsumed_FinanceReserve|2796.730| 
       109712     2017-04-04 09:41:08|strombezug|JSONMETER|electricityConsumed_CounterCurrent: 152.626|electricityConsumed_CounterCurrent|152.626| 
Attributes: 
   DbLogSelectionMode Exclude 
   DbLogType  Current/History 
   asyncMode  1 
   excludeDevs LaCrosse.*,clone_ESPEasy_ESP_G16.*,ESPEasy_ESP_G16.*,d.ESP_G16_GasZaehler.*,doif..*,DS.* 
   room       DbLog

myFHEMdb_LT:

Code Auswählen


Internals: 
   COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32 
   CONFIGURATION /opt/fhem/dblog/sqldb_lt.conf 
   DBMODEL    MYSQL 
   DEF        /opt/fhem/dblog/sqldb_lt.conf (myFHEMdb.*:DbFileSize.*|myFHEMdb.*:1970-01-01__COUNT_.*|Vitocrossal:.*LastDay.*|Vitocrossal:(appCountsPerDay|appCountsPerMonth).*|Vitocrossal:state_.*|.*_avg_.*|.*_max_.*|.*_min_.*|hc.Gasverbrauch_.*:(appCountsPerDay|appCountsPerWeek|appCountsPerMonth|appCountsPerYear).*|HZ_.*:temperature.*|WW_.*:temperature.*|Raumt.*:temperature.*|mys_103.*:temperature.*|mys_103.*:humidity.*|mys_103.*:dewpoint.*|.*:deviceMsg.*|.*:statElectricity.*) 
   MODE       asynchronous 
   NAME       myFHEMdb_LT 
   NR         231 
   NTFY_ORDER 50-myFHEMdb_LT 
   PID        4224 
   REGEXP     (myFHEMdb.*:DbFileSize.*|myFHEMdb.*:1970-01-01__COUNT_.*|Vitocrossal:.*LastDay.*|Vitocrossal:(appCountsPerDay|appCountsPerMonth).*|Vitocrossal:state_.*|.*_avg_.*|.*_max_.*|.*_min_.*|hc.Gasverbrauch_.*:(appCountsPerDay|appCountsPerWeek|appCountsPerMonth|appCountsPerYear).*|HZ_.*:temperature.*|WW_.*:temperature.*|Raumt.*:temperature.*|mys_103.*:temperature.*|mys_103.*:humidity.*|mys_103.*:dewpoint.*|.*:deviceMsg.*|.*:statElectricity.*) 
   STATE      connected 
   TYPE       DbLog 
   VERSION    2.14.4 
   dbconn     mysql:database=fhem_lt;host=192.168.0.25;port=3306 
   dbuser     fhem 
   Helper: 
     COLSET     1 
     DEVICECOL  64 
     EVENTCOL   512 
     READINGCOL 64 
     TYPECOL    64 
     UNITCOL    32 
     VALUECOL   128 
   Helper: 
     Dblog: 
       State: 
         Mydblog: 
           TIME       1491256740.03095 
           VALUE      connected 
         Myfhemdb: 
           TIME       1491256740.03662 
           VALUE      connected 
   Readings: 
     2017-04-04 09:43:44   CacheUsage      2 
     2017-04-04 09:43:44   NextSync        2017-04-04 09:44:14 or if CacheUsage 500 reached 
     2017-03-21 17:15:20   reduceLogState  reduceLogNbl finished. Rows processed: 0, deleted: 0, time: 0.00sec 
     2017-04-04 09:43:44   state           connected 
   Cache: 
     index      19417 
     Memcache: 
       19416      2017-04-04 09:43:44|strombezug|JSONMETER|statElectricityConsumed: Hour: 604 Day: 4743 Month: 33779 Year: 33779 (since: 2017-04-02 )|statElectricityConsumed|Hour: 604 Day: 4743 Month: 33779 Year: 33779 (since: 2017-04-02 )| 
       19417      2017-04-04 09:43:44|strombezug|JSONMETER|statElectricityConsumedToday: 4743|statElectricityConsumedToday|4743| 
Attributes: 
   DbLogSelectionMode Exclude 
   DbLogType  Current/History 
   asyncMode  1 
   room       DbLog

Rep.myFHEMdb.Size:

Code Auswählen


Internals: 
   CFGFN 
   DATABASE   fhem 
   DEF        myFHEMdb 
   LASTCMD    tableinfo 
   NAME       rep.myFHEMdb.Size 
   NOTIFYDEV  global,rep.myFHEMdb.Size 
   NR         18015 
   NTFY_ORDER 50-rep.myFHEMdb.Size 
   ROLE       Client 
   STATE      done 
   TYPE       DbRep 
   VERSION    4.11.4 
   Helper: 
     DBLOGDEVICE myFHEMdb 
     Cv: 
       aggregation no 
       aggsec     1 
       destr      2017-04-04 
       dsstr      1970-01-01 
       epoch_seconds_end 1491290647 
       mestr      04 
       msstr      01 
       testr      09:24:07 
       tsstr      01:00:00 
       wdadd      345600 
       yestr      2017 
       ysstr      1970 
   Helper: 
     Dblog: 
       1970-01-01__count__all_between_timestamps: 
         Mydblog: 
           TIME       1491290648.78851 
           VALUE      1172043 
         Myfhemdb: 
           TIME       1491290648.79239 
           VALUE      1172043 
       Info_history.data_index_length_mb: 
         Mydblog: 
           TIME       1491290945.37953 
           VALUE      336.89 
         Myfhemdb: 
           TIME       1491290945.38358 
           VALUE      336.89 
       State: 
         Mydblog: 
           TIME       1491251391.14047 
           VALUE      done 
         Myfhemdb: 
           TIME       1491251391.1444 
           VALUE      done 
   Readings: 
     2017-04-04 09:29:05   INFO_history.data_index_length_MB 336.89 
     2017-04-04 09:29:05   state           done 
   Dbloghash: 
     COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32 
     CONFIGURATION /opt/fhem/dblog/sqldb.conf 
     DBMODEL    MYSQL 
     DEF        /opt/fhem/dblog/sqldb.conf .*:.* 
     MODE       asynchronous 
     NAME       myFHEMdb 
     NR         229 
     NTFY_ORDER 50-myFHEMdb 
     PID        4224 
     REGEXP     .*:.* 
     STATE      connected 
     TYPE       DbLog 
     VERSION    2.14.4 
     dbconn     mysql:database=fhem;host=192.168.0.25;port=3306 
     dbuser     fhem 
     Helper: 
       COLSET     1 
       DEVICECOL  64 
       EVENTCOL   512 
       READINGCOL 64 
       TYPECOL    64 
       UNITCOL    32 
       VALUECOL   128 
     Helper: 
       Dblog: 
         Countcurrent: 
           Mydblog: 
             TIME       1491291632.33305 
             VALUE      1535 
           Myfhemdb: 
             TIME       1491291632.3382 
             VALUE      1535 
         Counthistory: 
           Mydblog: 
             TIME       1491291632.32342 
             VALUE      1172753 
           Myfhemdb: 
             TIME       1491291632.32741 
             VALUE      1172753 
         Lastrowsdeleted: 
           Mydblog: 
             TIME       1491256863.41192 
             VALUE      0 
           Myfhemdb: 
             TIME       1491256863.41605 
             VALUE      0 
         State: 
           Mydblog: 
             TIME       1491291632.01284 
             VALUE      countNbl 
           Myfhemdb: 
             TIME       1491291632.01807 
             VALUE      countNbl 
     Readings: 
       2017-04-04 09:44:47   CacheUsage      20 
       2017-04-04 09:44:47   NextSync        2017-04-04 09:45:17 or if CacheUsage 500 reached 
       2017-04-04 09:40:32   countCurrent    1535 
       2017-04-04 09:40:32   countHistory    1172753 
       2017-04-04 00:01:03   lastRowsDeleted 0 
       2017-04-04 09:44:47   state           connected 
     Cache: 
       index      109868 
       Memcache: 
         109849     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed: 152668|electricityConsumed|152668| 
         109850     2017-04-04 09:44:47|strombezug|JSONMETER|statElectricityConsumed: Hour: 613 Day: 4752 Month: 33788 Year: 33788 (since: 2017-04-02 )|statElectricityConsumed|Hour: 613 Day: 4752 Month: 33788 Year: 33788 (since: 2017-04-02 )| 
         109851     2017-04-04 09:44:47|strombezug|JSONMETER|statElectricityConsumedToday: 4752|statElectricityConsumedToday|4752| 
         109852     2017-04-04 09:44:47|strombezug|JSONMETER|electricityPower: 532|electricityPower|532| 
         109853     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_kWh: 152.668|electricityConsumed_kWh|152.668| 
         109854     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumedToday_kWh: 4.752|electricityConsumedToday_kWh|4.752| 
         109855     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_PowerCurrent: 480.000|electricityConsumed_PowerCurrent|480.000| 
         109856     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_PowerDayAver: 487.682|electricityConsumed_PowerDayAver|487.682| 
         109857     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyDay: 4.752|electricityConsumed_EnergyDay|4.752| 
         109858     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyMonth: -4887.332|electricityConsumed_EnergyMonth|-4887.332| 
         109859     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyYear: -4887.332|electricityConsumed_EnergyYear|-4887.332| 
         109860     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyMeter: -4887.332|electricityConsumed_EnergyMeter|-4887.332| 
         109861     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyCostDay: 1.212|electricityConsumed_EnergyCostDay|1.212| 
         109862     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyCostMonth: -1246.270|electricityConsumed_EnergyCostMonth|-1246.270| 
         109863     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyCostYear: -1246.270|electricityConsumed_EnergyCostYear|-1246.270| 
         109864     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_EnergyCostMeter: -1246.270|electricityConsumed_EnergyCostMeter|-1246.270| 
         109865     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_FinanceReserve: 2796.720|electricityConsumed_FinanceReserve|2796.720| 
         109866     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_CounterCurrent: 152.668|electricityConsumed_CounterCurrent|152.668| 
         109867     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumed_kWh_PowerDayAver: 0.715|electricityConsumed_kWh_PowerDayAver|0.715| 
         109868     2017-04-04 09:44:47|strombezug|JSONMETER|electricityConsumedToday_kWh_PowerDayAver: -0.994|electricityConsumedToday_kWh_PowerDayAver|-0.994| 
Attributes: 
   DbLogExclude state 
   icon       time_note 
   room       DbLog 
   showTableInfo %history%,%current% 
   showproctime 1 
   suppressReading ^(?!.*(INFO_history.data_index_length_MB)|(state)|(1970-01-01__COUNT__all_between_timestamps)).*$

Rep.myFHEMdb_LT.Size:

Code Auswählen


Internals: 
   CFGFN 
   DATABASE   fhem_lt 
   DEF        myFHEMdb_LT 
   LASTCMD    tableinfo 
   NAME       rep.myFHEMdb_LT.Size 
   NOTIFYDEV  global,rep.myFHEMdb_LT.Size 
   NR         18113 
   NTFY_ORDER 50-rep.myFHEMdb_LT.Size 
   ROLE       Client 
   STATE      done 
   TYPE       DbRep 
   VERSION    4.11.4 
   Helper: 
     DBLOGDEVICE myFHEMdb_LT 
     Cv: 
       aggregation no 
       aggsec     1 
       destr      2017-04-04 
       dsstr      1970-01-01 
       epoch_seconds_end 1491290843 
       mestr      04 
       msstr      01 
       testr      09:27:23 
       tsstr      01:00:00 
       wdadd      345600 
       yestr      2017 
       ysstr      1970 
   Helper: 
     Dblog: 
       1970-01-01__count__all_between_timestamps: 
         Mydblog: 
           TIME       1491290844.20598 
           VALUE      512601 
         Myfhemdb: 
           TIME       1491290844.21006 
           VALUE      512601 
       Info_history.data_index_length_mb: 
         Mydblog: 
           TIME       1491290927.01463 
           VALUE      336.89 
         Myfhemdb: 
           TIME       1491290927.01863 
           VALUE      336.89 
       State: 
         Mydblog: 
           TIME       1491251610.77049 
           VALUE      done 
         Myfhemdb: 
           TIME       1491251610.7746 
           VALUE      done 
   Readings: 
     2017-04-04 09:28:47   INFO_history.data_index_length_MB 336.89 
     2017-04-04 09:28:47   state           done 
   Dbloghash: 
     COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32 
     CONFIGURATION /opt/fhem/dblog/sqldb_lt.conf 
     DBMODEL    MYSQL 
     DEF        /opt/fhem/dblog/sqldb_lt.conf (myFHEMdb.*:DbFileSize.*|myFHEMdb.*:1970-01-01__COUNT_.*|Vitocrossal:.*LastDay.*|Vitocrossal:(appCountsPerDay|appCountsPerMonth).*|Vitocrossal:state_.*|.*_avg_.*|.*_max_.*|.*_min_.*|hc.Gasverbrauch_.*:(appCountsPerDay|appCountsPerWeek|appCountsPerMonth|appCountsPerYear).*|HZ_.*:temperature.*|WW_.*:temperature.*|Raumt.*:temperature.*|mys_103.*:temperature.*|mys_103.*:humidity.*|mys_103.*:dewpoint.*|.*:deviceMsg.*|.*:statElectricity.*) 
     MODE       asynchronous 
     NAME       myFHEMdb_LT 
     NR         231 
     NTFY_ORDER 50-myFHEMdb_LT 
     PID        4224 
     REGEXP     (myFHEMdb.*:DbFileSize.*|myFHEMdb.*:1970-01-01__COUNT_.*|Vitocrossal:.*LastDay.*|Vitocrossal:(appCountsPerDay|appCountsPerMonth).*|Vitocrossal:state_.*|.*_avg_.*|.*_max_.*|.*_min_.*|hc.Gasverbrauch_.*:(appCountsPerDay|appCountsPerWeek|appCountsPerMonth|appCountsPerYear).*|HZ_.*:temperature.*|WW_.*:temperature.*|Raumt.*:temperature.*|mys_103.*:temperature.*|mys_103.*:humidity.*|mys_103.*:dewpoint.*|.*:deviceMsg.*|.*:statElectricity.*) 
     STATE      connected 
     TYPE       DbLog 
     VERSION    2.14.4 
     dbconn     mysql:database=fhem_lt;host=192.168.0.25;port=3306 
     dbuser     fhem 
     Helper: 
       COLSET     1 
       DEVICECOL  64 
       EVENTCOL   512 
       READINGCOL 64 
       TYPECOL    64 
       UNITCOL    32 
       VALUECOL   128 
     Helper: 
       Dblog: 
         State: 
           Mydblog: 
             TIME       1491256740.03095 
             VALUE      connected 
           Myfhemdb: 
             TIME       1491256740.03662 
             VALUE      connected 
     Readings: 
       2017-04-04 09:45:20   CacheUsage      5 
       2017-04-04 09:45:20   NextSync        2017-04-04 09:45:50 or if CacheUsage 500 reached 
       2017-03-21 17:15:20   reduceLogState  reduceLogNbl finished. Rows processed: 0, deleted: 0, time: 0.00sec 
       2017-04-04 09:45:20   state           connected 
     Cache: 
       index      19429 
       Memcache: 
         19425      2017-04-04 09:45:20|mys_103_TempHum2Button|MYSENSORS_DEVICE|temperature: 16.2|temperature|16.2|°C 
         19426      2017-04-04 09:45:20|mys_103_TempHum2Button|MYSENSORS_DEVICE|humidity: 55.7|humidity|55.7|% 
         19427      2017-04-04 09:45:20|mys_103_TempHum2Button|MYSENSORS_DEVICE|dewpoint: 7.3|dewpoint|7.3| 
         19428      2017-04-04 09:45:20|strombezug|JSONMETER|statElectricityConsumed: Hour: 618 Day: 4757 Month: 33793 Year: 33793 (since: 2017-04-02 )|statElectricityConsumed|Hour: 618 Day: 4757 Month: 33793 Year: 33793 (since: 2017-04-02 )| 
         19429      2017-04-04 09:45:20|strombezug|JSONMETER|statElectricityConsumedToday: 4757|statElectricityConsumedToday|4757| 
Attributes: 
   DbLogExclude state 
   icon       time_note 
   room       DbLog 
   showTableInfo %history%,%current% 
   showproctime 1 
   suppressReading ^(?!.*(INFO_history.data_index_length_MB)|(state)|(1970-01-01__COUNT__all_between_timestamps)).*$

Zuletzt noch die Übersicht aus der Consolenabfrage:

Code Auswählen


[font=courier]+--------------------+-----------+
| Database           | Size (MB) |
+--------------------+-----------+
| fhem               |  248.9219 |
| fhem_lt            |   89.2031 |
| information_schema |    0.0088 |
| mysql              |    0.6784 |
| performance_schema |    0.0000 |
+--------------------+-----------+[/font]

Ich hoffe, ich konnte die relevanten Infos zusammenstellen um den Fehler zu finden (der ja meistens vor dem Bildschirm sitzt

) und bin froh, dass du mich unterstützt. Danke!

LG
Holger

DS_Starter · 04 April 2017, 10:30:25

Hallo Holger,

Lass mir Mal ein bisschen Zeit um das zu analysieren, ist viel Stoff. 😉
Aber ich habe jetzt eine Vermutung ... möglicherweise liegt es an der Namensähnlichkeit deiner DBs und ich habe irgendwo im Code ein zu ungenaues Matching auf ein RegEx. Die Größe ist ja überschlägig die Summe der history Tabelle beider DBs wenn ich das richtig sehe.

Grüße
Heiko

DS_Starter · 04 April 2017, 10:40:43

Was mir Grad noch einfällt.... deine Anmerkung zum Unterstrich. In SQL Statements wird der Unterstrich als Platzhalter interpretiert. Ich habe jetzt den select Code nicht vor Augen, aber wenn es dir möglich ist würde ich den DB-Namen vorsorglich ändern ohne Unterstrich.

Grüße
Heiko

Omega · 04 April 2017, 12:13:44

Hallo Heiko,

jetzt habe ich eine 3. DB angelegt (in mySQL: fhemlt, unter FHEM: myFHEMdbLT) und per expimp aus myFHEMdb_LT gefüllt.
Frage ich jetzt die Größe von myFHEMdbLT ab, komme ich auf 418 MB (ungefähr die Summe aller 3 DBs).
Es liegt also nicht am "_".

Fast alle DB-Zugriffe laufen richtig - nur bei der DB-Größe kommt es zur Abweichung.

Ich glaube, etwas gefunden zu haben
In dem kompletten Listing zu tabeinfo findest du überall den Timestamp: 2017-04-04_12:00:05 außer bei den Tabellen current und history:
- INFO_current.create_time 2017-03-23_00:09:28
- INFO_history.create_time 2017-03-23_00:09:28

Die DB habe ich aber gerade eben erst angelegt. Die Timestamps 2017-03-23_00:09:28 gehören zur DB fhem (mySQL-Name) bzw. myFHEMdb in FHEM.

[code]
Internals:
CFGFN
DATABASE fhemlt
DEF myFHEMdbLT
LASTCMD tableinfo
NAME rep.myFHEMdbLT.Agent
NOTIFYDEV global,rep.myFHEMdbLT.Agent
NR 26258
NTFY_ORDER 50-rep.myFHEMdbLT.Agent
ROLE Client
STATE done » ProcTime: 0.0087 sec
TYPE DbRep
VERSION 4.11.4
Helper:
DBLOGDEVICE myFHEMdbLT
Helper:
Dblog:
Info_character_sets.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_character_sets.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_character_sets.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_character_sets.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_character_sets.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_character_sets.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_character_sets.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_character_sets.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_character_sets.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_collations.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_collations.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collations.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collations.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_collations.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_collations.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_collations.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collations.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collations.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_collation_character_set_applicability.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_collation_character_set_applicability.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collation_character_set_applicability.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collation_character_set_applicability.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_collation_character_set_applicability.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_collation_character_set_applicability.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_collation_character_set_applicability.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collation_character_set_applicability.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collation_character_set_applicability.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_columns.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_columns.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_columns.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_columns.engine:
Mydblog:
TIME 1491300005.6177
VALUE MyISAM
Myfhemdb:
TIME 1491300005.64944
VALUE MyISAM
Info_columns.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Dynamic
Myfhemdb:
TIME 1491300005.64944
VALUE Dynamic
Info_columns.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_columns.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_columns.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_columns.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_column_privileges.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_column_privileges.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_column_privileges.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_column_privileges.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_column_privileges.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_column_privileges.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_column_privileges.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_column_privileges.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_column_privileges.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_engines.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_engines.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_engines.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_engines.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_engines.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_engines.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_engines.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_engines.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_engines.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_events.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_events.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_events.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_events.engine:
Mydblog:
TIME 1491300005.6177
VALUE MyISAM
Myfhemdb:
TIME 1491300005.64944
VALUE MyISAM
Info_events.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Dynamic
Myfhemdb:
TIME 1491300005.64944
VALUE Dynamic
Info_events.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_events.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_events.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_events.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_files.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_files.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_files.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_files.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_files.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_files.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_files.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_files.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_files.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_global_status.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_global_status.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_status.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_status.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_global_status.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_global_status.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_global_status.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_status.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_status.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_global_variables.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_global_variables.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_variables.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_variables.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_global_variables.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_global_variables.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_global_variables.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_variables.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_variables.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_buffer_page.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_buffer_page.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_buffer_page.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_buffer_page.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_buffer_page.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_buffer_page_lru.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_buffer_page_lru.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page_lru.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page_lru.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_buffer_page_lru.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_buffer_page_lru.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_buffer_page_lru.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page_lru.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page_lru.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_buffer_pool_stats.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_buffer_pool_stats.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_pool_stats.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_pool_stats.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_buffer_pool_stats.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_buffer_pool_stats.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_buffer_pool_stats.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_pool_stats.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_pool_stats.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_cmp.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_cmp.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmp.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmp.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_cmp.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_cmp.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_cmp.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_cmp.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_cmp.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_cmpmem.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_cmpmem.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmpmem.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmpmem.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_cmpmem.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_cmpmem.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_cmpmem.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_cmpmem

DS_Starter · 04 April 2017, 12:26:12

Das ist echt komisch, ich habe 4 fhem-Datenbanken in der MariaDB laufen und keine derartigen Effekte. Bei mir heissen sie fhem, fhemshort, fhemtest und fhemtest1. Also da muss ich nochmal in mich gehen. So etwas müsste doch bei mir auch auftreten ... echt eigenartig.
Ich habe MariaDB 5.5.53 und Perl 5.20.2.

LG
Heiko

Omega · 04 April 2017, 14:11:37

Mir ist eben aufgefallen, dass in meinem letzten Beitrag die Hälfte fehlt.
Lässt die Forensoftware nur eine bestimmte Größe in code-Tags zu? Oder ich habe irgendwann versehentlich den schließenden Tag verwurstet.
Ausgerechnet die Infos zu current und history haben gefehlt.

Also noch einmal, ich hoffe, jetzt komplett...
[code]
Internals:
CFGFN
DATABASE fhemlt
DEF myFHEMdbLT
LASTCMD tableinfo
NAME rep.myFHEMdbLT.Agent
NOTIFYDEV global,rep.myFHEMdbLT.Agent
NR 26258
NTFY_ORDER 50-rep.myFHEMdbLT.Agent
ROLE Client
STATE done » ProcTime: 0.0087 sec
TYPE DbRep
VERSION 4.11.4
Helper:
DBLOGDEVICE myFHEMdbLT
Helper:
Dblog:
Info_character_sets.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_character_sets.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_character_sets.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_character_sets.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_character_sets.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_character_sets.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_character_sets.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_character_sets.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_character_sets.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_collations.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_collations.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collations.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collations.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_collations.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_collations.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_collations.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collations.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collations.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_collation_character_set_applicability.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_collation_character_set_applicability.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collation_character_set_applicability.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_collation_character_set_applicability.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_collation_character_set_applicability.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_collation_character_set_applicability.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_collation_character_set_applicability.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collation_character_set_applicability.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_collation_character_set_applicability.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_columns.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_columns.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_columns.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_columns.engine:
Mydblog:
TIME 1491300005.6177
VALUE MyISAM
Myfhemdb:
TIME 1491300005.64944
VALUE MyISAM
Info_columns.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Dynamic
Myfhemdb:
TIME 1491300005.64944
VALUE Dynamic
Info_columns.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_columns.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_columns.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_columns.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_column_privileges.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_column_privileges.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_column_privileges.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_column_privileges.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_column_privileges.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_column_privileges.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_column_privileges.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_column_privileges.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_column_privileges.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_engines.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_engines.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_engines.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_engines.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_engines.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_engines.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_engines.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_engines.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_engines.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_events.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_events.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_events.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_events.engine:
Mydblog:
TIME 1491300005.6177
VALUE MyISAM
Myfhemdb:
TIME 1491300005.64944
VALUE MyISAM
Info_events.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Dynamic
Myfhemdb:
TIME 1491300005.64944
VALUE Dynamic
Info_events.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_events.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_events.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_events.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_files.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_files.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_files.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_files.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_files.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_files.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_files.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_files.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_files.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_global_status.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_global_status.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_status.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_status.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_global_status.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_global_status.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_global_status.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_status.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_status.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_global_variables.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_global_variables.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_variables.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_global_variables.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_global_variables.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_global_variables.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_global_variables.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_variables.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_global_variables.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_buffer_page.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_buffer_page.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_buffer_page.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_buffer_page.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_buffer_page.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_buffer_page_lru.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_buffer_page_lru.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page_lru.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_page_lru.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_buffer_page_lru.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_buffer_page_lru.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_buffer_page_lru.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page_lru.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_page_lru.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_buffer_pool_stats.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_buffer_pool_stats.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_pool_stats.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_buffer_pool_stats.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_buffer_pool_stats.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_buffer_pool_stats.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_buffer_pool_stats.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_pool_stats.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_buffer_pool_stats.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_cmp.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_cmp.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmp.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmp.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_cmp.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_cmp.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_cmp.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_cmp.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_cmp.table_type:
Mydblog:
TIME 1491300005.6177
VALUE SYSTEM_VIEW
Myfhemdb:
TIME 1491300005.64944
VALUE SYSTEM_VIEW
Info_innodb_cmpmem.create_time:
Mydblog:
TIME 1491300005.6177
VALUE 2017-04-04_12:00:05
Myfhemdb:
TIME 1491300005.64944
VALUE 2017-04-04_12:00:05
Info_innodb_cmpmem.data_free_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmpmem.data_index_length_mb:
Mydblog:
TIME 1491300005.6177
VALUE 0.00
Myfhemdb:
TIME 1491300005.64944
VALUE 0.00
Info_innodb_cmpmem.engine:
Mydblog:
TIME 1491300005.6177
VALUE MEMORY
Myfhemdb:
TIME 1491300005.64944
VALUE MEMORY
Info_innodb_cmpmem.row_format:
Mydblog:
TIME 1491300005.6177
VALUE Fixed
Myfhemdb:
TIME 1491300005.64944
VALUE Fixed
Info_innodb_cmpmem.table_collation:
Mydblog:
TIME 1491300005.6177
VALUE utf8_general_ci
Myfhemdb:
TIME 1491300005.64944
VALUE utf8_general_ci
Info_innodb_cmpmem.table_name:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_cmpmem.table_schema:
Mydblog:
TIME 1491300005.6177
VALUE information_schema
Myfhemdb:
TIME 1491300005.64944
VALUE information_schema
Info_innodb_cmpmem.tabl

Omega · 04 April 2017, 14:19:50

Jetzt wurde meine Änderung auch verschluckt (in der Vorschau war noch alles ok).

Der wichtige Rest (current und history). Wenn das jetzt auch nicht funktioniert, hänge ich den Output als Datei an.

Code Auswählen


     2017-04-04 12:00:05   INFO_current.create_time 2017-03-23_00:09:28 
     2017-04-04 12:00:05   INFO_current.data_free_MB 18.00 
     2017-04-04 12:00:05   INFO_current.data_index_length_MB 0.27 
     2017-04-04 12:00:05   INFO_current.engine InnoDB 
     2017-04-04 12:00:05   INFO_current.row_format Compact 
     2017-04-04 12:00:05   INFO_current.table_collation utf8_bin 
     2017-04-04 12:00:05   INFO_current.table_name fhem 
     2017-04-04 12:00:05   INFO_current.table_schema fhem 
     2017-04-04 12:00:05   INFO_current.table_type BASE_TABLE 
     2017-04-04 12:00:05   INFO_history.create_time 2017-03-23_00:09:28 
     2017-04-04 12:00:05   INFO_history.data_free_MB 18.00 
     2017-04-04 12:00:05   INFO_history.data_index_length_MB 418.08 
     2017-04-04 12:00:05   INFO_history.engine InnoDB 
     2017-04-04 12:00:05   INFO_history.row_format Compact 
     2017-04-04 12:00:05   INFO_history.table_collation utf8_bin 
     2017-04-04 12:00:05   INFO_history.table_name fhem 
     2017-04-04 12:00:05   INFO_history.table_schema fhem 
     2017-04-04 12:00:05   INFO_history.table_type BASE_TABLE 
     2017-04-04 12:00:05   background_processing_time 0.0101 
     2017-04-04 12:00:05   sql_processing_time 0.0087 
     2017-04-04 12:00:05   state           done 
   Dbloghash: 
     CFGFN 
     COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32 
     CONFIGURATION /opt/fhem/dblog/sqldblt.conf 
     DBMODEL    MYSQL 
     DEF        /opt/fhem/dblog/sqldblt.conf (myFHEMdb.*:DbFileSize.*|myFHEMdb.*:1970-01-01__COUNT_.*|Vitocrossal:.*LastDay.*|Vitocrossal:(appCountsPerDay|appCountsPerMonth).*|Vitocrossal:state_.*|.*_avg_.*|.*_max_.*|.*_min_.*|hc.Gasverbrauch_.*:(appCountsPerDay|appCountsPerWeek|appCountsPerMonth|appCountsPerYear).*|HZ_.*:temperature.*|WW_.*:temperature.*|Raumt.*:temperature.*|mys_103.*:temperature.*|mys_103.*:humidity.*|mys_103.*:dewpoint.*|.*:deviceMsg.*|.*:statElectricity.*) 
     MODE       synchronous 
     NAME       myFHEMdbLT 
     NR         26143 
     NTFY_ORDER 50-myFHEMdbLT 
     PID        4224 
     REGEXP     (myFHEMdb.*:DbFileSize.*|myFHEMdb.*:1970-01-01__COUNT_.*|Vitocrossal:.*LastDay.*|Vitocrossal:(appCountsPerDay|appCountsPerMonth).*|Vitocrossal:state_.*|.*_avg_.*|.*_max_.*|.*_min_.*|hc.Gasverbrauch_.*:(appCountsPerDay|appCountsPerWeek|appCountsPerMonth|appCountsPerYear).*|HZ_.*:temperature.*|WW_.*:temperature.*|Raumt.*:temperature.*|mys_103.*:temperature.*|mys_103.*:humidity.*|mys_103.*:dewpoint.*|.*:deviceMsg.*|.*:statElectricity.*) 
     STATE      connected 
     TYPE       DbLog 
     VERSION    2.14.4 
     dbconn     mysql:database=fhemlt;host=192.168.0.25;port=3306 
     dbuser     fhem 
     Helper: 
       COLSET     1 
       DEVICECOL  64 
       EVENTCOL   512 
       READINGCOL 64 
       TYPECOL    64 
       UNITCOL    32 
       VALUECOL   128 
     Helper: 
       Dblog: 
         State: 
           Mydblog: 
             TIME       1491298884.62611 
             VALUE      connected 
           Myfhemdb: 
             TIME       1491298884.62999 
             VALUE      connected 
     Readings: 
       2017-04-04 14:02:27   CacheUsage      2 
       2017-04-04 14:02:27   NextSync        2017-04-04 14:02:57 or if CacheUsage 500 reached 
       2017-04-04 14:02:27   state           connected 
     Cache: 
       index      1122 
       Memcache: 
         1121       2017-04-04 14:02:27|strombezug|JSONMETER|statElectricityConsumed: Hour: 21 Day: 7604 Month: 36640 Year: 36640 (since: 2017-04-02 )|statElectricityConsumed|Hour: 21 Day: 7604 Month: 36640 Year: 36640 (since: 2017-04-02 )| 
         1122       2017-04-04 14:02:27|strombezug|JSONMETER|statElectricityConsumedToday: 7604|statElectricityConsumedToday|7604| 
Attributes: 
   devStateIcon connected:10px-kreis-gelb .*disconnect:10px-kreis-rot .*done:10px-kreis-gruen 
   icon       security 
   room       DbLog 
   showproctime 1 
   stateFormat { ReadingsVal("$name","state", undef) eq "running" ? "renaming" : ReadingsVal("$name","state", undef). " » ProcTime: ".ReadingsVal("$name","sql_processing_time", undef)." sec"} 
   timeout    3600

LG
Holger

JoeALLb · 04 April 2017, 15:03:07

zur Info:
Folgende Fehlermeldungen erhalte ich nach update von fhem im Log:

Code Auswählen

Use of uninitialized value $dbconn in split at ./FHEM/93_DbRep.pm line 257, <$fh> line 2754.
Use of uninitialized value in numeric comparison (<=>) at fhem.pl line 1939, <$fh> line 3564.

vielleicht ist es was von Bedeutung?!?

sG Joe

Omega · 04 April 2017, 16:39:34

Ich habe jetzt noch eine 4. DB angelegt - ganz anderer Name (test bzw. myTESTdb), um auch Probleme von Namensähnlichkeiten ausschließen zu können.

Nach Anlage der DB (ohne Import weiterer Daten) erhalte ich als Größe 423 MB - also wieder die Summe aller DBs. Auch hier wieder die falschen Timestamps bei
- INFO_current.create_time 2017-03-23_00:09:28
- INFO_history.create_time 2017-03-23_00:09:28
bzw. die in der falschen DB gelesenen Tabellen.

LG
Holger

DS_Starter · 04 April 2017, 23:38:28

Hallo Holger,

ich konnte bisher nicht wirklich einen Fehler finden. Ist allerdings auch schon spät heute.
Bei mir werden die Daten sauber für die jeweilige fhem-DB gelistet.
Ich habe mal eine neue Version hier angehängt. Prüfe mal bei dir ob sich etwas ändert.

Vielleicht noch ein Hinweis .... ich verwende für jede einzelne DB einen separaten Nutzer der auch nur die Rechte auf diese DB hat, also 4 DBs bei mir mit 4 separaten Nutzer. Das habe ich auch aus Sicherheitsgründen so eingerichtet damit bei meiner ganzen Testerei nichts schief geht.

Checke dies auch mal bei dir. Ich kann mir eigentlich nur so etwas im Metabereich vorstellen, sonst müsste ich doch auch diese Effekte haben.

Grüße
Heiko

Omega · 05 April 2017, 10:29:34

Hallo Heiko,

danke für deine Unterstützung.
Leider hat sich mit der neuen Version nichts geändert.

Linux ist bei mir eine große Baustelle, d.h. Rechtevergabe, Nutzung mehrerer User für unterschiedliche DBs, die FHEM aber dann wieder übergreifend alle bearbeiten kann, übersteigt derzeitig meinen Kenntnisstand.

Die Konfiguration meiner (momentan) 4 DBs habe ich auch noch einmal überprüft (sowohl die Definition in FHEM (der Verweis auf die richtige .conf) als auch die jeweilige .conf selber): alles mMn richtig konfiguriert.

Jetzt stelle ich die Frage mal anders herum: was würde bei dir passieren, wenn du bei allen DBs den gleichen User hast? Vielleicht ist das tatsächlich der Unterschied, warum bei dir die Daten sauber separiert werden. Jede Abfrage auf eine deiner DBs kann aufgrund der Rechtevergabe nur ein eindeutiges Ergebnis liefern, d.h. die Selektion erfolgt vielleicht nicht wirklich aufgrund der DB-Angabe in der Konfiguration von DbRep in FHEM sondern aufgrund der Abgrenzung des Users in der .conf auf Systemebene. Bei mir werden beim Aufruf von get tableinfo alle vorhandenen DBs gelesen und die ermittelten Werte aufsummiert (so ähnlich wie bei dem Aufruf in der Console). get tableinfo dürfte eigentlich aber nur auf die DB zugreifen, die in DbRep festgelegt ist. Ich weiß: alles nur Spekulation - aber zumindest klingt es logisch.

Das kann aber nur bei dieser speziellen Abfrage sein. Die anderen Zugriffe, also das Zählen der Records oder das separieren und Löschen bestimmter Einträge erfolgt mMn fehlerfrei.

LG
Holger

DS_Starter · 06 April 2017, 21:06:33

Hallo Holger,

kurzer Zwischenstand.
Also es liegt an den Rechten des users. Mit root bekomme ich das gleiche Ergebnis wie du.
Hier habe ich die eine Version angehängt die dein Problem erst einmal lösen wird. Es wird aber nicht die Größe der einzelnen Tabellen ausgegeben was in ursprünglich wollte.
Aber ich schaue mal ob ich das noch besser lösen kann ...

Grüße
Heiko