scott.marlowe wrote:
Just to add to the clutch here, also check your bdflush settings (if
you're on linux) or equivalent (if you're not.)
Many times the swapping algo in linux can be quite bursty if you have it
set to move too many pages at a time during cleanup / flush.
According to vmstat it
Hello,
We're running a set of Half-Life based game servers that lookup user
privileges from a central PostgreSQL 7.3.4 database server (I recently
ported the MySQL code in Adminmod to PostgreSQL to be able to do this).
The data needed by the game servers are combined from several different
Currently there's only a few users in the database for testing purposes,
and most of the time the user lookup's take 2-3 ms (I have syslog'ing of
queries and duration turned on), but several times per hour the duration
for one of the queries is 2-3 seconds (1000 times larger), while the
On 28 Aug 2003 at 1:07, Anders K. Pedersen wrote:
Hello,
We're running a set of Half-Life based game servers that lookup user
privileges from a central PostgreSQL 7.3.4 database server (I recently
ported the MySQL code in Adminmod to PostgreSQL to be able to do this).
The data needed
,
Russ Garrett
[EMAIL PROTECTED] wrote:
Subject: [PERFORM] Queries sometimes take 1000 times the normal time
Hello,
We're running a set of Half-Life based game servers that lookup user
privileges from a central PostgreSQL 7.3.4 database server (I recently
ported the MySQL code in Adminmod
On 28 Aug 2003 at 10:02, Russell Garrett wrote:
The web site queries will jump up one or two orders of magnitude (I have
seen a normally 100ms query take in excess of 30 seconds) in duration at
seemingly random points. It's not always when the transactions are
committing, and it doesn't seem
The web site queries will jump up one or two orders of magnitude (I
have seen a normally 100ms query take in excess of 30 seconds) in
duration at seemingly random points. It's not always when the
transactions are committing, and it doesn't seem to be during
checkpointing either. The same
Shridhar Daithankar wrote:
On 28 Aug 2003 at 1:07, Anders K. Pedersen wrote:
We're running a set of Half-Life based game servers that lookup user
privileges from a central PostgreSQL 7.3.4 database server (I recently
ported the MySQL code in Adminmod to PostgreSQL to be able to do this).
The
Tom Lane wrote:
Anders K. Pedersen [EMAIL PROTECTED] writes:
Currently there's only a few users in the database for testing purposes,
and most of the time the user lookup's take 2-3 ms (I have syslog'ing of
queries and duration turned on), but several times per hour the duration
for one of the
With regards to other jobs on the server, there is a MySQL server on it
as well, which from time to time has some multi-second queries generated
from a webserver also on this host, but the MySQL is running with nice
10 (PostgreSQL isn't nice'd).
Do those MySQL queries hit disk hard?
I've
Rod Taylor wrote:
With regards to other jobs on the server, there is a MySQL server on it
as well, which from time to time has some multi-second queries generated
from a webserver also on this host, but the MySQL is running with nice
10 (PostgreSQL isn't nice'd).
Do those MySQL queries hit disk
11 matches
Mail list logo