!mduWVRtKzYinVAelXP:matrix.org

MWStake General

138 Members
MediaWiki Stakeholders' Group general discussion https://commonmark.org/help/34 Servers

Load older messages


SenderMessageTime
28 Sep 2020
@freephile:matrix.orgrundg

I upgraded to 34.x for FamilySearch wikis, and for some reason I'm getting crushed. I'm getting 503 'Service Unavailable' errors -- apparently because MySQL is overloaded. When pages do load, they can be extremely slow. I just had a page load

929 kB transferred
1.8 MB resources
Finish: 27.35 s
DOMContentLoaded: 18.58 s
Load: 27.40 s```
19:58:10
@freephile:matrix.orgrundg I know I should carefully review any changes to MySQL configuration, but one thing I'm seeing in the logs are lots of slow queries for queries like this:
SELECT /* */ r.rev_user_text FROMrevisionr,pagepWHERE p.page_title = 'Spain_Murcia.jpg' ORDER BY r.rev_id ASC LIMIT 1;
Does that seem weird to you?
20:00:16
@freephile:matrix.orgrundg
# Time: 200928 19:27:37
# User@Host: wiki_app_user[wiki_app_user] @ localhost []
# Thread_id: 69228  Schema: wiki_en  QC_hit: No
# Query_time: 55.121532  Lock_time: 0.000053  Rows_sent: 1  Rows_examined: 7653047
# Rows_affected: 0
20:00:27
@hexmode:matrix.orghexmode
In reply to @tgr:matrix.org
Voting on the MediaWiki logo variant has started! https://www.mediawiki.org/wiki/Project:Proposal_for_changing_logo_of_MediaWiki,_2020/Round_2
I know this is too complicated for a logo, but this photo from Reddit should give someone inspiration for a logo.
20:33:08
@hexmode:matrix.orghexmodeMilky Way over a sunflower in Denmark.jpg
Download Milky Way over a sunflower in Denmark.jpg
20:33:17
@tgr:matrix.orgtgr
In reply to @freephile:matrix.org
I know I should carefully review any changes to MySQL configuration, but one thing I'm seeing in the logs are lots of slow queries for queries like this:
SELECT /* */ r.rev_user_text FROMrevisionr,pagepWHERE p.page_title = 'Spain_Murcia.jpg' ORDER BY r.rev_id ASC LIMIT 1;
Does that seem weird to you?
that's a Descartian product of you entire page and revision tables
21:41:28
@tgr:matrix.orgtgrgiven the LIMIT 1, I'm not sure why it is slow, but it is an entirely nonsensical query21:41:57
@tgr:matrix.orgtgr presumably there should be a p.page_id = r.rev_page in there 21:43:16
@freephile:matrix.orgrundgThe slow queries I was experiencing were coming from the ApprovedRevs extension.23:03:14
@freephile:matrix.orgrundghttps://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/ApprovedRevs/+/refs/heads/master/includes/ApprovedRevs.php#38023:05:24
29 Sep 2020
@freephile:matrix.orgrundgFrom looking at the code, It appears that the JOIN condition is not being used? I didn't have time to test it b/c I had to disable it.02:56:19
@hexmode:matrix.orghexmode
In reply to @freephile:matrix.org
The slow queries I was experiencing were coming from the ApprovedRevs extension.
I think I've seen this before... Can you at least report a bug? (because I didn't I don't think)
02:57:04
@hexmode:matrix.orghexmodeAnd cc me02:57:08
@freephile:matrix.orgrundgWill do02:57:32
@hexmode:matrix.orghexmode

From support desk q about hiding html comments in search results:

Also try setting: $wgAdvancedSearchHighlighting = true;

For some reason this helps show less wikitext markdown in the results.

Does anyone else know if this is intended?

19:13:41
30 Sep 2020
@freephile:matrix.orgrundg
In reply to @hexmode:matrix.org
I think I've seen this before... Can you at least report a bug? (because I didn't I don't think)
I subscribed you (and Yaron) to https://phabricator.wikimedia.org/T225027 with updated comments
19:01:18
@hexmode:matrix.orghexmodety19:03:15
1 Oct 2020
@richardheigl:matrix.orgrichardheiglNow it has happened. Habemus blogum: https://mediawikiexperts.blog/ Announcement on mediawiki-l is sent but apparently not yet approved. 11:32:47
@hexmode:matrix.orghexmodedoes anybody know how MW communicates with JS/Parsoid? I'm seeing some cookie confusion (I think that's what it is anyway) from two identically configured wikis. The only difference (that i have found so far) is that it works on the one running the parsoid container under podman and doesn't work on the one running the parsoid container under docker.17:03:25
@hexmode:matrix.orghexmode(Oh, and the working one is Centos7 and the not-working one is Centos6, hence the podman/docker difference.)17:04:15
@hexmode:matrix.orghexmodeHmm... I'm going to look at another problem now, but I just got hit with a big carp -- I'm gonna try switching to docker on the dev server.17:05:26
2 Oct 2020
@tgr:matrix.orgtgrParsoid cookies for private wikis was a very recent fix00:05:02
@tgr:matrix.orgtgr richardheigl: there shouldn't be a need for approval if you are subscibed 00:05:23
@richardheigl:matrix.orgrichardheigl
In reply to @tgr:matrix.org
richardheigl: there shouldn't be a need for approval if you are subscibed
That was interesting. Because it turned out that a term in the header had caused the filtr. Now I already missed the popular terms "Free, Drugs, Pills, Sex, Fast Credit", but it was one of those terms: "Launch" "MediaWiki" "Experts" "Blog" or a combination of them. 😂
13:13:48
@richardheigl:matrix.orgrichardheigl
In reply to @tgr:matrix.org
richardheigl: there shouldn't be a need for approval if you are subscibed
* That was interesting. Because it turned out that a term in the header had triggered the filter. Now I already missed the popular terms "Free, Drugs, Pills, Sex, Fast Credit", but it was one of those terms: "Launch" "MediaWiki" "Experts" "Blog" or a combination of them. 😂
13:14:39
4 Oct 2020
@jtm-lis:matrix.orgjtm-lis richardheigl: Hi Richard its Julien I made the mistake of replying to the mailing list with a suggestion for the mediawikiexperts.blog upon announcement. It just hit me later the next day, that is really not the place for that. Sorry I am still new to mailing lists and the community at large. 01:56:45
@jtm-lis:matrix.orgjtm-lisWhere should I submit feedback for https://mediawikiexperts.blog/ ? Phabricator? 01:57:25
@jtm-lis:matrix.orgjtm-lis

I commented on **T1029: Contact Installatron **and T187514: Documentation for bringing a MediaWiki site online.

I am not sure really of the lay of the land or the proper protocols for getting involved in a greater capacity. I guess it would start with a personal introduction? I am a bit at a loss at the moment, on how to do get more involved. Most of it isn't of great importance, but I really feel strongly about looking at mediawiki.org protections so I can update the documentation as I learn mediawiki.

04:43:37
@jtm-lis:matrix.orgjtm-lis *

I commented on **T1029: Contact Installatron ** and T187514: Documentation for bringing a MediaWiki site online.

I am not sure really of the lay of the land or the proper protocols for getting involved in a greater capacity. I guess it would start with a personal introduction? I am a bit at a loss at the moment, on how to do get more involved. Most of it isn't of great importance, but I really feel strongly about looking at mediawiki.org protections so I can update the documentation as I learn mediawiki.

04:43:52
@jtm-lis:matrix.orgjtm-lis *

I commented on T1029: Contact Installatron and T187514: Documentation for bringing a MediaWiki site online.

I am not sure really of the lay of the land or the proper protocols for getting involved in a greater capacity. I guess it would start with a personal introduction? I am a bit at a loss at the moment, on how to do get more involved. Most of it isn't of great importance, but I really feel strongly about looking at mediawiki.org protections so I can update the documentation as I learn mediawiki.

04:43:58

Show newer messages


Back to Room ListRoom Version: