At the moment, all the search feature does is tells you there are no title matches (regardless of what you search for), and directs you to a Google search. The go button still works, so at the moment "go" is the only way to do a title search. I had assumed the dev. team has this under control and I worked around it, but I've had a new user (Susurrus) complain directly to me, asking me to forward his complaint on to here. So here it is. I know about "miser mode", but this isn't miser mode, it's nonexistent mode. What's going on?
-- Tim Starling.
_________________________________________________________________ Hotmail now available on Australian mobile phones. Go to http://ninemsn.com.au/mobilecentral/hotmail_mobile.asp
On Sun, 2003-04-27 at 17:20, Tim Starling wrote:
At the moment, all the search feature does is tells you there are no title matches (regardless of what you search for), and directs you to a Google search. The go button still works, so at the moment "go" is the only way to do a title search. I had assumed the dev. team has this under control and I worked around it, but I've had a new user (Susurrus) complain directly to me, asking me to forward his complaint on to here. So here it is. I know about "miser mode", but this isn't miser mode, it's nonexistent mode. What's going on?
I've just gone ahead and turned the title search back on. I mean, heck, who wants to actually be able to read or write anything on the wiki? Much better to be able to search it -- _if_ you're lucky enough to get through at all.
Hooray!
If it starts to suck too much (which it likely will come morning), I'll disable it again.
-- brion vibber (brion @ pobox.com)
Hello, I'm sysop on the french Wikipedia. I want to run a SQL request to change all "Egypte", "egypte" and "égypte" to "Égypte" (french name for Egypt) on the body articles of the french data base. (I will make the titles rename by hand) Someone are against that ? What request do you advise ? Regards,
Aoineko
PS : I consider that "who say nothing agree", so if I have no comment since last week I will run my request (of course I will send the command line first).
Guillaume Blanchard wrote:
Hello, I'm sysop on the french Wikipedia. I want to run a SQL request to change all "Egypte", "egypte" and "égypte" to "Égypte" (french name for Egypt) on the body articles of the french data base. (I will make the titles rename by hand) Someone are against that ? What request do you advise ?
since we're having server problems at the moment, I'd advise against it.
etant donné que le serveur rame comme c'est pas possible en ce moment, je dirais qu'il vaudrait mieux attendre. Ou faire les articles un par un - tu les copies-colles dans un editeur de texte qui fait les expression regulieres. (je te conseile TextPad)
since we're having server problems at the moment, I'd advise against it.
etant donné que le serveur rame comme c'est pas possible en ce moment, je dirais qu'il vaudrait mieux attendre. Ou faire les articles un par un - tu les copies-colles dans un editeur de texte qui fait les expression regulieres. (je te conseile TextPad)
Il y en a vraiment beaucoup d'article a faire... N'y a t'il pas des plages horraires pas trop encombre ? Je suis pres a faire tourner la requete a n'importe quel heure de ton choix. Si je fait une recherche avec l'outil de recherche sur "Egypte antique" puis "egypte antique" et enfin "égypte antique", ca me parait plus lourd que une seul requete qui cherche les trois et les remplacent par "Égypte antique". Je me trompe ? Tu penses vraiment que c'est une requete lourde ? Si tu as peur que j'abime la base avec une erreure de requete, je prefere que tu me le dise franchement ;o) Merci pour la reponse.
Aoineko
Guillaume Blanchard wrote:
Tu penses vraiment que c'est une requete lourde ? Si tu as peur que j'abime la base avec une erreure de requete, je prefere que tu me le dise franchement ;o)
non non c'est pas ca! mais j'ai l'impression que le serveur rame pour un rien en ce moment. Mais je ne suis pas developeur, c'est juste ce que j'entends sur cette liste. Les plages peu encombrees: quand les Americains dorment!!!
Tu penses vraiment que c'est une requete lourde ? Si tu as peur que j'abime la base avec une erreure de requete, je prefere que tu me le dise franchement ;o)
non non c'est pas ca! mais j'ai l'impression que le serveur rame pour un rien en ce moment. Mais je ne suis pas developeur, c'est juste ce que j'entends sur cette liste. Les plages peu encombrees: quand les Americains dorment!!!
Ils dorment a quel heure UTC ? :oP
Aoineko
Guillaume Blanchard wrote:
Tu penses vraiment que c'est une requete lourde ? Si tu as peur que j'abime la base avec une erreure de requete, je prefere que tu me le dise franchement ;o)
non non c'est pas ca! mais j'ai l'impression que le serveur rame pour un rien en ce moment. Mais je ne suis pas developeur, c'est juste ce que j'entends sur cette liste. Les plages peu encombrees: quand les Americains dorment!!!
Ils dorment a quel heure UTC ? :oP Aoineko
Sorry, but can you stop writing french in Wikitech-l? Try an appropriate wikifr-l. I don't have any time to learn french only for this international mailinglist. Thanks.
Smurf
On Mon, Apr 28, 2003 at 06:28:06PM +0200, Thomas Corell wrote:
Guillaume Blanchard wrote:
Tu penses vraiment que c'est une requete lourde ? Si tu as peur que j'abime la base avec une erreure de requete, je prefere que tu me le dise franchement ;o)
non non c'est pas ca! mais j'ai l'impression que le serveur rame pour un rien en ce moment. Mais je ne suis pas developeur, c'est juste ce que j'entends sur cette liste. Les plages peu encombrees: quand les Americains dorment!!!
Ils dorment a quel heure UTC ? :oP Aoineko
Sorry, but can you stop writing french in Wikitech-l? Try an appropriate wikifr-l. I don't have any time to learn french only for this international mailinglist. Thanks.
No, it's ok to write in any language. Especially apropriate are multilingual posts.
Hi, Again Aoineko from the french Wikipedia. Here is a good way of updating all articles that contain ' foo1 ' to ' foo2 ' ? Don't panic, I will not run this request just now ;o) It's just to know. There are many spelling errors we can solve with it (especially for french accent accent). What is the best time to run SQL request (not especially this one) ?
UPDATE LOW_PRIORITY cur SET cur_text = REPLACE( cur_text, '% foo1 %', '% foo2 %') WHERE cur_text LIKE '% foo1 %';
Aoineko
UPDATE LOW_PRIORITY cur SET cur_text = REPLACE( cur_text, '% foo1 %', '% foo2 %') WHERE cur_text LIKE '% foo1 %';
oups, copy&past error :o) here is the right version:
UPDATE LOW_PRIORITY cur SET cur_text = REPLACE( cur_text, ' foo1 ', ' foo2 ') WHERE cur_text LIKE '% foo1 %';
Aoineko
Just a thought... Wouldn't it be less load on the server if someone were to download the fr database dump, run a query on their local machine to figure out what entries need updated, then run several specific queries on the live database to update the appropriate entries?
This way, we could avoid the full text matching on "%whatever%" to discover which entries need updating.
Please forgive me if my SQL knowledge is lacking, or if a solution has already been found during discussion in French... I'd love to read (in English) what was said in the French discussion of this thread, if anyone cares to translate...
Jason Richey
tarquin wrote:
Guillaume Blanchard wrote:
Tu penses vraiment que c'est une requete lourde ? Si tu as peur que j'abime la base avec une erreure de requete, je prefere que tu me le dise franchement ;o)
non non c'est pas ca! mais j'ai l'impression que le serveur rame pour un rien en ce moment. Mais je ne suis pas developeur, c'est juste ce que j'entends sur cette liste. Les plages peu encombrees: quand les Americains dorment!!!
Wikitech-l mailing list Wikitech-l@wikipedia.org http://www.wikipedia.org/mailman/listinfo/wikitech-l
to Thomas Corell :
Sorry, but can you stop writing french in Wikitech-l? Try an appropriate wikifr-l. I don't have any time to learn french only for this
international
mailinglist. Thanks.
Sorry but I just answered Tarquin who has the kindness to answer my english question in my native language.
to Tomasz Wegrzanowski :
No, it's ok to write in any language. Especially apropriate are multilingual posts.
Thanks, I will try to post in english (or both).
to Jason Richey :
Just a thought... Wouldn't it be less load on the server if someone were to download the fr database dump, run a query on their local machine to figure out what entries need updated, then run several specific queries on the live database to update the appropriate entries?
This way, we could avoid the full text matching on "%whatever%" to discover which entries need updating.
If we download the "current" french database each time we want to run a query (to get the last updated entry) it is heavy, isn't it ?
Please forgive me if my SQL knowledge is lacking, or if a solution has already been found during discussion in French... I'd love to read (in English) what was said in the French discussion of this thread, if anyone cares to translate...
We only discuss the better time to run a query according to the americans sleeping time ;o) By the way I didn't get the answer yet, what is the best time to run queries (not especially this one) ? It perhaps not the right time to speak about query since you have so much performence problems ! To be continued... (later)
Aoineko
On Sun, 2003-04-27 at 17:20, Tim Starling wrote:
At the moment, all the search feature does is tells you there are no title matches (regardless of what you search for), and directs you to a Google search. The go button still works, so at the moment "go" is the only way to do a title search. I had assumed the dev. team has this under control and I worked around it, but I've had a new user (Susurrus) complain directly to me, asking me to forward his complaint on to here. So here it is. I know about "miser mode", but this isn't miser mode, it's nonexistent mode. What's going on?
I've just gone ahead and turned the title search back on. I mean, heck, who wants to actually be able to read or write anything on the wiki? Much better to be able to search it -- _if_ you're lucky enough to get through at all.
As I wrote you by private mail, I think people would be much more willing to accept a temporary deactivation of the sysop SQL feature, which, if at all, should be run on a separate machine (possibly a mirror, could really be 1-2 days out of date).
As for the search itself, I would like to know *why* it is slow. A simple title search should really cause no problems. Could it be that the search is delayed by other factors? How fast is it when it is run without load?
Regards,
Erik
On Mon, 2003-04-28 at 03:30, Erik Moeller wrote:
As I wrote you by private mail, I think people would be much more willing to accept a temporary deactivation of the sysop SQL feature, which, if at all, should be run on a separate machine (possibly a mirror, could really be 1-2 days out of date).
I have only very rarely seen slowdowns caused by sysops making SQL queries, whereas the special pages and the search cause much more continuous states of slowness as they are constantly pounded on.
As for the search itself, I would like to know *why* it is slow. A simple title search should really cause no problems.
Becuase they don't happen in isolation; there are a lot of searches.
-- brion vibber (brion @ pobox.com)
On Mon, 2003-04-28 at 03:30, Erik Moeller wrote:
As I wrote you by private mail, I think people would be much more willing to accept a temporary deactivation of the sysop SQL feature, which, if at all, should be run on a separate machine (possibly a mirror, could really be 1-2 days out of date).
I have only very rarely seen slowdowns caused by sysops making SQL queries, whereas the special pages and the search cause much more continuous states of slowness as they are constantly pounded on.
Yes, you are correct, they are very rare. But if they occur, they will effectively slow down all other queries for the time they run. Because of the risk that such an out of control query can slow us down for hours, I think there's really no argument that can be made for keeping them active, unless we implement a timeout (which would mean you or Lee, because I frankly never cared much about the SQL feature). That doesn't mean that we should not consider other options for speedings things up as well (although I agree that the server situation needs to improve in any case).
Regards,
Erik
wikitech-l@lists.wikimedia.org