multilingual_title_de

Jochen Hoff · Post by **Jochen Hoff** » Mon Jan 11, 2016 8:31 pm

K<nn mir mal wer verraten woherdieses schript aufgerufen wird? Ih habe auf Duckhome.net kein solches Plugin in der Liste, also muss es woanders her kommen.

Das Probllem ist, das Duckhome plötzlich sehr langsam geworden ist und mein Hoster mir folgendes Mitteilte:

"Auffällig ist, dass MySQL für alle gezeigten Queries wesentlich mehr
Datensätze untersuchen musste, als es zurückgegeben hat. Das deutet auf
sog. Full Table Scans hin, wobei ich das mindestens bei einem Query
nicht nachvollziehen konnte.
Aber vielleicht ist das Produkt aus den Tabellen-Verknüpfungen auch
einfach zu groß um effektiv verarbeitet werden zu können.

Was mir spontan ins Auge gefallen ist, sind Properties mit dem Namen
"multilingual_title_de". Soweit ich weiß ist das keine Funktion die S9Y
so mitbringt, sondern per Plugin nachgerüstet wird. Sollte dem so sein,
schau doch mal, ob Du das Plugin wirklich brauchst oder eher weg tun kannst.
Wobei das natürlich nicht das einzigste ist. "

Hier der Output des Logs:

Time Id Command Argument
# Time: 160111 17:27:01
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.354258 Lock_time: 0.000067 Rows_sent: 5 Rows_examined: 31268
use duckhome_db1;
SET timestamp=1452529621;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529614
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 15.446632 Lock_time: 0.037587 Rows_sent: 25 Rows_examined: 23241
SET timestamp=1452529621;
SELECT
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452529800 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id

ORDER BY orderkey DESC, timestamp DESC
LIMIT 1675, 25;
# Time: 160111 17:27:05
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 12.299370 Lock_time: 0.000257 Rows_sent: 1 Rows_examined: 52472
SET timestamp=1452529625;
SELECT
e.isdraft AS orderkey,
ep_cache_extended.value AS ep_cache_extended,
ep_cache_body.value AS ep_cache_body,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email

FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN tb_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN tb_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
WHERE isdraft = 'false' AND e.timestamp <= 1452529800 AND (ep_access.property IS NULL OR ep_access.value = 'public') AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')
GROUP BY e.id

ORDER BY orderkey DESC, last_modified DESC
LIMIT 1;
# Time: 160111 17:27:11
Query_time: 6.040128 Lock_time: 0.000123 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529891;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529885
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:33
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.985227 Lock_time: 0.000093 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529893;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529887
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:35
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.749800 Lock_time: 0.000108 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529895;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529889
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.023760 Lock_time: 0.000106 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529895;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529889
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:36
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.553538 Lock_time: 0.222695 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529896;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529890
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.584208 Lock_time: 0.000110 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529896;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529891
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:41
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.779132 Lock_time: 0.000105 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529901;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529895
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:46
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.342892 Lock_time: 0.000071 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529906;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529900
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:47
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.038121 Lock_time: 0.000108 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529907;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529901
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:48
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.609230 Lock_time: 0.000136 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529908;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529903
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:50
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.930440 Lock_time: 0.000137 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529910;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529904
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:51
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.249322 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529911;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529905
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:52
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.438452 Lock_time: 0.000078 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529912;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529906
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:53
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.342757 Lock_time: 0.000091 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529913;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529907
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.639211 Lock_time: 0.000126 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529913;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529906
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:31:55
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.529346 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529915;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529908
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.655709 Lock_time: 0.000115 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529915;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529909
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.687785 Lock_time: 0.037317 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529915;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529910
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:57
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.328910 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529917;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529911
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:31:58
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.250560 Lock_time: 0.000118 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529918;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529911
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.532782 Lock_time: 0.000109 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529918;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529912
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:00
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.548475 Lock_time: 0.000094 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529920;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529913
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.098582 Lock_time: 0.000103 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529920;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529915
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:02
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.900111 Lock_time: 0.000085 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529922;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529916
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:04
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.058314 Lock_time: 0.000120 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529924;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529919
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:10
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.377497 Lock_time: 0.000136 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529930;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529925
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:13
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.110090 Lock_time: 0.000102 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529933;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529926
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:17
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.303260 Lock_time: 0.000119 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529937;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529930
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:18
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.421579 Lock_time: 0.000088 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529938;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529931
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.606196 Lock_time: 0.000083 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529938;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529930
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:21
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.978071 Lock_time: 0.000174 Rows_sent: 25 Rows_examined: 21691
SET timestamp=1452529941;
SELECT
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id

ORDER BY orderkey DESC, timestamp DESC
LIMIT 125, 25;
# Time: 160111 17:32:22
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.066724 Lock_time: 0.000092 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529942;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529937
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:23
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.161230 Lock_time: 0.000100 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529943;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529938
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 15.087449 Lock_time: 0.000075 Rows_sent: 12373 Rows_examined: 74437
use duckhome_db2;
SET timestamp=1452529943;
select distinct ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`object`, thf.`comment`, thf.`version`, thf.`page_id` from `tiki_actionlog` ta
inner join (select th.`version`, th.`comment`, th.`pageName`, th.`lastModif`, tp.`page_id` from `tiki_history` as th LEFT OUTER JOIN `tiki_pages` tp ON tp.`pageName` = th.`pageName` AND tp.`version` = th.`version`) as thf on ta.`object`=thf.`pageName` and ta.`lastModif`=thf.`lastModif` and ta.`objectType`='wiki page' where true order by ta.`lastModif` asc;
# Time: 160111 17:32:24
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.578128 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
use duckhome_db1;
SET timestamp=1452529944;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529937
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:28
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.298866 Lock_time: 0.000096 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529948;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529943
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:29
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.579969 Lock_time: 0.000111 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529949;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529944
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:35
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.715054 Lock_time: 0.000073 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529955;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529950
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:36
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.117969 Lock_time: 0.000102 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529956;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529950
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.227077 Lock_time: 0.000098 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529956;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529950
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:38
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.449672 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529958;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529951
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:42
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.924960 Lock_time: 0.000610 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529962;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529956
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.356291 Lock_time: 0.000135 Rows_sent: 25 Rows_examined: 25541
SET timestamp=1452529962;
SELECT
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id

ORDER BY orderkey DESC, timestamp DESC
LIMIT 3975, 25;
# Time: 160111 17:32:43
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.417991 Lock_time: 0.000110 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529963;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529958
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.841790 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529963;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529958
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:47
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.048079 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529967;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529961
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:49
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.027549 Lock_time: 0.000072 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529969;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529964
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:32:51
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.411341 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529971;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529964
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:53
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.426847 Lock_time: 0.000101 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529973;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529967
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 8.709759 Lock_time: 0.000143 Rows_sent: 25 Rows_examined: 21591
SET timestamp=1452529973;
SELECT
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id

ORDER BY orderkey DESC, timestamp DESC
LIMIT 25, 25;
# Time: 160111 17:32:54
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.023299 Lock_time: 0.000142 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529974;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529969
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:32:59
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.128092 Lock_time: 0.000116 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529979;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529973
ORDER BY timestamp DESC
LIMIT 5;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.357933 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529979;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529974
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:00
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.197549 Lock_time: 0.000107 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529980;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529974
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:02
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.037850 Lock_time: 0.000127 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529982;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529977
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:03
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 5.135741 Lock_time: 0.000115 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452529983;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529978
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:17
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 13.262791 Lock_time: 0.000134 Rows_sent: 12373 Rows_examined: 74437
use duckhome_db2;
SET timestamp=1452529997;
select distinct ta.`action`, ta.`lastModif`, ta.`user`, ta.`ip`, ta.`object`, thf.`comment`, thf.`version`, thf.`page_id` from `tiki_actionlog` ta
inner join (select th.`version`, th.`comment`, th.`pageName`, th.`lastModif`, tp.`page_id` from `tiki_history` as th LEFT OUTER JOIN `tiki_pages` tp ON tp.`pageName` = th.`pageName` AND tp.`version` = th.`version`) as thf on ta.`object`=thf.`pageName` and ta.`lastModif`=thf.`lastModif` and ta.`objectType`='wiki page' where true order by ta.`user` desc;
# Time: 160111 17:33:18
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.244533 Lock_time: 0.000097 Rows_sent: 20 Rows_examined: 84846
use duckhome_db1;
SET timestamp=1452529998;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529992
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:33:19
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.942869 Lock_time: 0.000086 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452529999;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452529992
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 7.767833 Lock_time: 0.000178 Rows_sent: 25 Rows_examined: 21966
SET timestamp=1452529999;
SELECT
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id

ORDER BY orderkey DESC, timestamp DESC
LIMIT 400, 25;
# Time: 160111 17:33:20
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.021639 Lock_time: 0.000104 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452530000;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529994
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:22
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.841931 Lock_time: 0.000129 Rows_sent: 5 Rows_examined: 31268
SET timestamp=1452530002;
SELECT DISTINCT id,
title,
timestamp,
epm.value AS multilingual_title
FROM tb_entries AS e
LEFT OUTER JOIN tb_entrycat AS ec ON id = ec.entryid LEFT OUTER JOIN tb_category AS c ON ec.categoryid = c.categoryid

LEFT OUTER JOIN tb_entryproperties AS epm
ON (epm.entryid = e.id AND epm.property = 'multilingual_title_de')

WHERE isdraft = 'false' AND timestamp <= 1452529995
ORDER BY timestamp DESC
LIMIT 5;
# Time: 160111 17:33:23
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 8.053549 Lock_time: 0.000168 Rows_sent: 25 Rows_examined: 21566
SET timestamp=1452530003;
SELECT
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
tb_entries AS e
LEFT JOIN tb_authors a
ON e.authorid = a.authorid
LEFT JOIN tb_entrycat ec
ON e.id = ec.entryid
LEFT JOIN tb_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN tb_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN tb_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND (e.authorid = 1) AND e.timestamp <= 1452530100 AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id

ORDER BY orderkey DESC, timestamp DESC
LIMIT 25;
# Time: 160111 17:33:26
# User@Host: duckhome[duckhome] @ [127.0.0.1]
# Query_time: 6.206794 Lock_time: 0.000090 Rows_sent: 20 Rows_examined: 84846
SET timestamp=1452530006;
SELECT et.tag, count(et.tag) AS total
FROM tb_entrytags AS et
LEFT OUTER JOIN tb_entries AS e
ON et.entryid = e.id
WHERE e.isdraft = 'false' AND e.timestamp <= 1452530000
GROUP BY et.tag
HAVING count(et.tag) >= 2
ORDER BY total DESC LIMIT 20;
# Time: 160111 17:33:28

Post by **yellowled** » Mon Jan 11, 2016 9:43 pm

Jochen Hoff wrote:Was mir spontan ins Auge gefallen ist, sind Properties mit dem Namen "multilingual_title_de". Soweit ich weiß ist das keine Funktion die S9Y so mitbringt, sondern per Plugin nachgerüstet wird.

* serendipity_plugin_recententries
* serendipity_event_entrypaging
* serendipity_event_multilingual (logisch)

Recent entries und Entrypaging verwendest Du, Multilingual offenbar nicht. Die würde ich mal testhalber deaktivieren (sowohl einzeln als auch zusammen).

Kommt mir aber komisch vor, weil ich mir ziemlich sicher bin, beide schon verwendet und noch nie dadurch Performanceprobleme gehabt zu haben. Vielleicht gibst Du für die weitere Diagnose nochmal die PHP-/MySQL-Versionen an und schaust, ob alle Plugins aktuell sind?

YL

Jochen Hoff · Post by **Jochen Hoff** » Tue Jan 12, 2016 6:36 am

yellowled wrote: * serendipity_plugin_recententries

Das kann ich gar nicht wegnehmen, weil dass dem Schließen des Blogs gleichkommt, da niemand mehr die neuen Artikel erkennen kann.

PHP 5.5.28 ist meine Version. SQL finde ich heute raus.

Aber das kann eigentlich nicht die Lösung sein Ich vermute viel eher dass die Datenbank einfach zu groß ist, oder ich plugins am laufen habe die einfach nicht mehr zu Serendipity 2.0.2 passen.

Alle Plugins sind aktuell.

Timbalu · Post by **Timbalu** » Tue Jan 12, 2016 11:20 am

Jochen Hoff wrote:Aber das kann eigentlich nicht die Lösung sein Ich vermute viel eher dass die Datenbank einfach zu groß ist, oder ich plugins am laufen habe die einfach nicht mehr zu Serendipity 2.0.2 passen.

Ich würde es ähnlich, aber anders sagen:
Es kann eigentlich nicht an den genannten queries liegen, sie erstrecken sich ja auch auf einen Zeitraum von mehreren Minuten (6). Und auch nicht an den genannten Plugins.

Du hast einfach sehr viel zusammengepackt auf deiner "/" Startseite, was an dem Template liegt, denn es möchte soviel als möglich auf die Übersicht packen. Das zusammen mit Resourcenlimits (zb Memory RAM, max PHP Processes, max MySQL Connections) deines Hosters und der jeweiligen sonstigen Auslastung zum Zeitpunkt, kann die Sache verlangsamen. Das Durchsuchen von ~84500 entries und ~31000 entryproperties sollte MySql generell aber keineswegs an Grenzen führen, außer sie sind durch ISP Resourcen limitiert.

So richtig nachvollziehen läßt sich das meines Erachtens auch nur auf den /archive links, zb http://duckhome.net/tb/archives/2009/03/summary.html (von der Vollanzeige nicht zu reden). Da könnte dein Limit in irgend einer Weise einfach erreicht sein. Du solltest deinen Rahmen also überdenken.

Post by **onli** » Tue Jan 12, 2016 12:43 pm

All diese SQL-Abfragen stammen aus dem slow query log?

Zur Info: Serendipity 2.1 hat einen integrierten Cache der Datenbankabfrage, der hier eventuell helfen würde. Noch nichts für deine Seite da die 2.1 noch keine Beta hat, aber als Zukunftsaussicht.

Auch möglich, dass für diese Plugins einfach die passenden Indexe fehlen. Ich bin nicht sicher, wie wir das am besten testen würden.

Jochen Hoff · Post by **Jochen Hoff** » Tue Jan 12, 2016 3:22 pm

onli wrote:All diese SQL-Abfragen stammen aus dem slow query log?

Zur Info: Serendipity 2.1 hat einen integrierten Cache der Datenbankabfrage, der hier eventuell helfen würde. Noch nichts für deine Seite da die 2.1 noch keine Beta hat, aber als Zukunftsaussicht.

Auch möglich, dass für diese Plugins einfach die passenden Indexe fehlen. Ich bin nicht sicher, wie wir das am besten testen würden.

Ja das eigentliche Log ist noch viel länger, ich hab es verkürzt. Ich den Blog auch früher schon auf einer Beta laufen lassen und würde das jedereit wieder riskieren.

Ach ja. SQL ist 5.163 nicht das neueste aber bisher lief es. Mein Hoster meint der integriete Cache der Datenbank hört sich gut. Mir persönlich fehtl einfach die Ahnung. So schlimm wie jetzt war es noch nie, Gateway Timeout und ansonsten Wartezeiten von bis zu 20 Sekunden.

Da aber weder der Hoster noch ich was geändert habe, kann es sich meiner Meinung nach nur über einen Überlauf handeln. Mein vager Verdacht geht in die Richtung, dass die PHP Aufrufe in der Datenbanik velangsamt werden und eventuell sich gegenseitig ausbremsen weil da irgendwas überläuft.

Post by **onli** » Tue Jan 12, 2016 3:43 pm

Wenn du wirklich mutig mit der neuen Version bist, kannst du auf die Alpha der 2.1 upgraden und dann den Cache aktivieren. Siehe https://www.onli-blogging.de/1476/Seren ... sucht.html, Dirk testet das bereits, soweit ich weiß erfolgreich. Es sollte das Problem reduzieren, aber es bliebe immer noch rauszufinden woran es liegt. Ich vermute immer noch, dass der Query da ohne Index läuft und deinen Server überfordert.

2.1 ist allerdings noch keine Beta, du bräuchtest auf jeden Fall ein gutes Backup.

Post by **MarioH** » Wed Jan 13, 2016 9:51 am

Eventuell hat Don Chambers noch eine Idee, die Seite läuft ja anscheinend mit dem Kinetic-Theme?
Müsste man dann aber wohl was im englischen Teil des Forums schreiben.

Gruß
Mario

Jochen Hoff · Post by **Jochen Hoff** » Mon Jan 25, 2016 9:16 am

Ihr werdet es kaum glauben. Das Problem liegt daran, das wir einfach zu viele Freetags hatten. Nachdem wir das Plugin rausgenommen haben, summt die Kiste wieder wie ein Bienchen.

Timbalu · Post by **Timbalu** » Mon Jan 25, 2016 12:03 pm

Interessant! Kannst du mir mal eine ungefähre Hausnummer geben?

Jochen Hoff · Post by **Jochen Hoff** » Mon Jan 25, 2016 12:49 pm

Timbalu wrote:Interessant! Kannst du mir mal eine ungefähre Hausnummer geben?

Ich kann sie jetzt nicht mehr sehen, aber ein paar hundert waren es. Den Bolg gibt es seit 2003.

Post by **bernd_d** » Mon Jan 25, 2016 6:34 pm

Ich würde ja prinzipiell ein wenig mehr Optimierung betreiben an der Seite, zumindest was mich als oberflächlichen Besucher angeht ohne Anspruch darauf, dass das an den Ladezeiten tatsächlich etwas ändert.

Das Entenbild z.B. eine unkomprimierte JPG. Da kann man gut 80-100kb sparen.
RSS-Feeds für Kategorien (Seitenleiste) erscheint mir unnötig und braucht bestimmt auch einiges an Code zum generieren.
Du solltest erweiterte Einträge nutzen und nicht alle Artikel im Teaser-Bereich schreiben, dadurch werden die Übersichtsseiten sehr lang.
In der Seitenleiste können m.E. die RSS-Feed-Blöcke raus, du hast sie doch ohnehin in der oberen Navigation drin.
Archiv kann aus der Seitenleiste eigentlich auch raus, in der jetzigen Darstellung würde genauso gut ein Link in der oberen Navi reichen.
Der Admin-Login braucht m.E. in der Seitenleiste ebenfalls nicht zu sein, sowas kann man den Autoren auch so mitteilen.
Flattr ist doch auch tot oder? Kann mir nicht vorstellen, dass darüber tatsächlich Umsätze generiert werden.

...und zu den ganzen Sachen, die der Werbeblocker an Tracking-Code schon blockiert, sag ich besser gar nix.

multilingual_title_de

multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de

Re: multilingual_title_de