[vz-dev] s0vz: Überflüssige Updates bei jedem Insert?

[Heiko Baumann]

Hi Andi
>
>
> Ja- Commit 8ac2c5039273b590aec2a9890f87400c08b949a8 liegt dazwischen.
>
>
> Ich kann's nicht mehr nachvollziehen:
>
> SELECT e0_.id AS id0, e0_.uuid AS uuid1, e0_.type AS type2, p1_.id AS 
> id3, p1_.pkey AS pkey4, p1_.value AS value5, e0_.class AS class6, 
> p1_.entity_id AS entity_id7 FROM entities e0_ LEFT JOIN properties p1_ 
> ON e0_.id = p1_.entity_id WHERE (e0_.uuid = ?) AND e0_.class IN 
> ('channel', 'aggregator') ORDER BY p1_.pkey ASC
> START TRANSACTION
> INSERT INTO data (timestamp, value, channel_id) VALUES (?, ?, ?)
> COMMIT
>
> Bist Du sicher dass der Code den Du siehst auch wirklich der ist der 
> ausgeführt wird?
  Ich bin sicher, dass das aktueller Code ist, ja. Zur Sicherheit habe 
ich gerade eben nochmal kurz mitgeloggt:


/usr/sbin/mysqld, Version: 5.5.33-0+wheezy1 ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
140113 *20:16:29 *118183 Connect  vz at localhost on volkszaehler
                 118183 Query    SELECT e0_.id AS id0, e0_.uuid AS 
uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS 
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities 
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid = 
'89277390-f2dc-11e2-94d6-9984a2fec1dc') AND e0_.class IN ('channel', 
'aggregator') ORDER BY p1_.pkey ASC
                 118183 Query    START TRANSACTION
                 118183 Query    INSERT INTO data (timestamp, value, 
channel_id) VALUES ('1389640589168', '1', 13)
                 118183 Query    UPDATE properties SET value = '1' WHERE 
id = 65
                 118183 Query    UPDATE properties SET value = '1' WHERE 
id = 63
                 118183 Query    UPDATE properties SET value = '1000' 
WHERE id = 61
                 118183 Query    commit
                 118183 Quit
140113 20:16:43 118184 Connect  vz at localhost on volkszaehler
                 118184 Query    SELECT e0_.id AS id0, e0_.uuid AS 
uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS 
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities 
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid = 
'267f2810-f2dc-11e2-8d7c-cb14f79472e0') AND e0_.class IN ('channel', 
'aggregator') ORDER BY p1_.pkey ASC
                 118184 Query    START TRANSACTION
                 118184 Query    INSERT INTO data (timestamp, value, 
channel_id) VALUES ('1389640603905', '3.81', 6)
                 118184 Query    UPDATE properties SET value = '1' WHERE 
id = 28
                 118184 Query    UPDATE properties SET value = '1' WHERE 
id = 26
                 118184 Query    commit
                 118184 Quit
140113 20:16:44 118185 Connect  vz at localhost on volkszaehler
                 118185 Query    SELECT e0_.id AS id0, e0_.uuid AS 
uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS 
value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities 
e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid = 
'c80251e0-f2db-11e2-8178-ef2453dba49c') AND e0_.class IN ('channel', 
'aggregator') ORDER BY p1_.pkey ASC
                 118185 Query    START TRANSACTION
140113 20:16:45 118185 Query    INSERT INTO data (timestamp, value, 
channel_id) VALUES ('1389640604969', '3.62', 1)
                 118185 Query    UPDATE properties SET value = '1' WHERE 
id = 2
                 118185 Query    commit
                 118185 Quit
140113 *20:16:46 *118075 Query    SET GLOBAL general_log = 'OFF'

Insofern würde ich schon sagen, dass die updates immer noch heftig 
einprasseln...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.volkszaehler.org/pipermail/volkszaehler-dev/attachments/20140113/dc719fd0/attachment-0001.html>