On 28 Aug 2003 at 20:16, Anders K. Pedersen wrote:
> 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
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 d
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.
---(end of broadca
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
> 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'
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
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 dat
Rod Taylor wrote:
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),
>> 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
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 se
time.
Any ideas?
Cheers,
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 dat
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 ne
"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 queri
> 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
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
tab
15 matches
Mail list logo
