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?
Ed Poor SQL Programmer since 1994
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?
It's implicit, we don't perform any explicit locks at all. In fact, it's a pretty fragile system...
You want me to fix it for you? Should I join the developers mailing
list?
Yes, please!
-- brion vibber (brion @ pobox.com)
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
So what do we need table locking for? You want me to fix it for you? Should I join the developers mailing list?
Ed,
we could definitely use your help on wikitech-l, there's a lot of optimizable SQL, some tables aren't indexed where they should be, the PHP code can probably also use some tweaking. Particularly high load operations are internal link resolution (see my recent wikitech-l mail) and orphaned pages listing (haven't tested the latter on the main Wikipedia because it took so long on my local install).
Regards,
Erik
wikipedia-l@lists.wikimedia.org