[Wikipedia-l] LAG

[Jonathan Walther]

On Mon, Nov 11, 2002 at 05:16:06PM -0500, Poor, Edmund W wrote:
>Yeah, you also said:
>
>MySQL has really crappy table locking, and blocks everything when certain slow operations are being done. We're looking into replacing it with Postgresql, which is said to scale better. But, first I have to adapt the code, change the table definitions, make sure it works on my home server, set up a test installation here before we go converting hundreds of megabytes of databasey goodness willy-nilly. --Brion 21:16 Oct 29, 2002 (UTC) 
>
>So what do we need table locking for? You want me to fix it for you? Should I join the developers mailing list? 

Um, the problem is that the SQL is intermingled with the PHP code, so
it's a bastard to go through and remove the MySQLisms.  I myself have
modified the DatabaseFunctions.php file, but am dragging my feet on
going through all the table definitions and making sure the data types
are appropriate/compatible with Postgres.

Jonathan

-- 
                     Geek House Productions, Ltd.

  Providing Unix & Internet Contracting and Consulting,
  QA Testing, Technical Documentation, Systems Design & Implementation,
  General Programming, E-commerce, Web & Mail Services since 1998

Phone:   604-435-1205
Email:   djw at reactor-core.org
Webpage: http://reactor-core.org
Address: 2459 E 41st Ave, Vancouver, BC  V5R2W2
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 307 bytes
Desc: not available
Url : http://lists.wikimedia.org/pipermail/wikipedia-l/attachments/20021111/7cfabc06/attachment.pgp