This is the wrong mailing list, but it appears that there is something
wrong with the cl_from index on the dewiki.labsdb tool labs replicas.
For some reason this index is not being used.
However this issue is not present on the other replicas, even when
querying dewiki data.
For example, using enwiki.labsdb:
$ sql enwiki
MariaDB [enwiki_p]> select page_id, cl_to from dewiki_p.page left join
dewiki_p.categorylinks on cl_from = page_id where !page_namespace and
!page_is_redirect LIMIT 30;
Works fine.
So this is definitely a bug in tool labs. You should report it to the
cloud services team so that they can fix it.
--
Brian
On Wed, Jun 28, 2017 at 7:46 AM, Martin Domdey <animalia(a)gmx.net> wrote:
Ah, before June 22nd the query has been done in less
than 4 minutes [sic!].
Now it lasts more than 1 hour!
--
Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.
Am 28.06.2017, 09:41, Martin Domdey <animalia(a)gmx.net> schrieb:
Hi!
MariaDB [dewiki_p]> select page_id, cl_to
from page left join categorylinks on cl_from = page_id
where !page_namespace and !page_is_redirect
order by page_title;
Before the query has been done, I get a database close but I cannot filter
the query more.
What can I do?
Greetings,
Martin
--
Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail
gesendet. _______________________________________________ Mediawiki-api
mailing list Mediawiki-api(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
_______________________________________________
Mediawiki-api mailing list
Mediawiki-api(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-api