Wikitech-l April 2002

wikitech-l@lists.wikimedia.org

15 participants
36 discussions

"Real-world" comparison of MySQL with PostgreSQL
by Neil Harris 04 May '02

04 May '02

For anyone who is interested, Tim Perdue has performed a set of benchmarks comparing MySQL with PostgreSQL See his article at http://www.phpbuilder.com/columns/tim20000705.php3?page=2 and http://www.phpbuilder.com/columns/tim20000705-res.php3 for the raw results. For read performance, they are comparable, with mySQL performing about 50% better. In the 10% write case, however, Postgres kept going beyond the client-concurrency load where MySQL falls over. -- Neil

3 2

Bogus edit conflict
by Pierre Abbat 30 Apr '02

30 Apr '02

Can anyone explain this? I just spent about two dozen times trying to submit the new page "Chelicerata" and finally got an edit conflict. It says that someone submitted the page while I was submitting it, but the page the other guy submitted is blank. If it were the same as what I tried to submit, then the other guy would be my previous attempt, and if it contained more text, then my previous attempt succeeded and someone else then edited it. phma

1 0

Re: Bug in diff
by Axel Boldt 28 Apr '02

28 Apr '02

> {'''Q'''} should be {'''Q'''0}. Yup, that's fixed in the current version. It was due to the "feature" of php which treats "" and "0" both as 'false'. Axel

1 0

Bug in diff
by Pierre Abbat 27 Apr '02

27 Apr '02

http://www.wikipedia.com/wiki/P-adic_numbers&diff=yes {'''Q'''} should be {'''Q'''0}. phma

1 0

polish, and esperanto wikipedias, and slowness in the new software
by Jason Richey 26 Apr '02

26 Apr '02

Hello, I am a programmer here at Bomis, and I have been asked to get pl.wikipedia.com and es.wikipedia.com running on the new (PHP/MySQL based) software. I have also been asked to help resolve the performance issues that Wikipedia has been having. I am new to this list, so I'll be taking a little time to look over the archives before I start doing anything drastic, but I wanted to introduce myself. -- "Jason C. Richey" <jasonr(a)bomis.com>

1 0

Vacation
by Jimmy Wales 26 Apr '02

26 Apr '02

I'm on vacation until next Sunday... but I will try to get to some Wikipedia related requests, particularly for those related to the slowdowns. I'll also instruct Jason to set up the pl2.wikipedia.com server, in consultation with people on the tech list. jasonr(a)bomis.com is his direct address. Jason, can you help the wikipedia folks out? We're most interested in getting the pl site on a test wikipedia with mysql, and the esperanto one, too. Also, give them access_logs or whatever they need to help diagnose the slowness!

1 0

Fun new features to slow the server down more
by Brion L. VIBBER 26 Apr '02

26 Apr '02

After much clamoring from many quarters, I decided to add to special:whatlinkshere a list of pages that link to the current page via redirects. Doesn't seem to have exploded so far... Feel free to improve it / integrate it better with the rest of the list. One potential problem is that a redirect page could, conceivably, have additional links in the text after the #REDIRECT line, and the current code would think those links were actual redirects and list them accordingly. But, well, they shouldn't. Also, I've disabled redirect-following for diffs. If I want to diff a redirect page, goshdarnit, I want to diff the redirect page, not the page that it (now) redirects to! -- brion vibber (brion @ pobox.com)

1 0

Orphans, skins
by Magnus Manske 25 Apr '02

25 Apr '02

I just noticed the link tables in the 'pedia are (still?) inconsistent. For example, [[803]] shows up on the Orphans page, but 15 (!) articles link to it. - Currently, we generate the skins from within the code. This really starts getting ugly. How about: * For each skin, there's a dummy HTML file * It contains special markup like <a href="@@linkRandomPage">@@textRandomPage</a> * These could be enclosed in <showRandomPages>....</showRandomPages> * On display, the HTML is adapted to the viewer and the page to be viewed (no "delete this page" on special pages etc.) This would make it easy to keep the skins up-to-date, add more skins, and keep the code relatively clean. The HTML for the skins could even be stored as a "wikipedia:" article. Thinking of it, we could store the whole PHP script as protected articles and update the running version from there... ('scuse me, going berserk;)

1 0

Simple changes
by lcrocker＠nupedia.com 24 Apr '02

24 Apr '02

There are a couple of simple fixes I can make easily, like fixing the <dl> code, recognizing ".JPG", etc. I have downloaded the latest stuff from CVS. What would be a quick and convenient way to get those fixes done? Posting a diff to this list? Sending a complete file to one of the maintainers? I'm not sure I want or need CVS checkin access; this is not something I'll be doing regularly. 0

2 1

Connection to database lost
by Pierre Abbat 24 Apr '02

24 Apr '02

After several unsuccessful attempts to find out about Willard van Orman Quine, I get this error: Warning: MySQL: Link to server lost, unable to reconnect in /home/wiki-newest/work-http/databaseFunctions.php on line 11 Could not connect to MySQL server: phma

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Wikitech-l April 2002