drupal.org MySQL database issues - Mailing list pgsql-advocacy

From John DeSoi
Subject drupal.org MySQL database issues
Date
Msg-id A4881DB1-4A27-482A-8408-4F89D2867C0D@pgedit.com
Whole thread Raw
Responses Re: drupal.org MySQL database issues
Re: drupal.org MySQL database issues
List pgsql-advocacy
Maybe they could be convinced to use the "other" database supported
by Drupal :).


http://drupal.org/node/144228

What's the deal?

The root of the problem that our database server is overloaded. This
is causing table locks:

Table locking is also disadvantageous under the following scenario:
* A client issues a SELECT that takes a long time to run.
* Another client then issues an UPDATE on the same table.
This client waits until the SELECT is finished.
* Another client issues another SELECT statement on the same
table. Because UPDATE has higher priority than SELECT, this
SELECT waits for the UPDATE to finish, and for the first
SELECT to finish.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


pgsql-advocacy by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: 2nd annual State of Lightning Talks at OSCON
Next
From: Lukas Kahwe Smith
Date:
Subject: Re: drupal.org MySQL database issues