On Jan 21, 2008, at 1:58 AM, Adrian Moisey wrote:
Perhaps, if you want to avoid I/O caused by temp tables (but it's
not at
checkpoint time, so perhaps this has nothing to do with your
problem),
you could try raising temp_buffers.
How can I find out if temp_buffers is being exceeded ?
You
Hi
Perhaps, if you want to avoid I/O caused by temp tables (but it's not at
checkpoint time, so perhaps this has nothing to do with your problem),
you could try raising temp_buffers.
How can I find out if temp_buffers is being exceeded ?
--
Adrian Moisey
System Administrator | CareerJunction
On Jan 18, 2008 4:58 AM, Adrian Moisey <[EMAIL PROTECTED]> wrote:
>
> We use a lot of checkpoints in our database, we don't care about these
> much. We think this is causing the checkpoint to write a lot of data at
> checkpoint time. Can we stop this behavior ?
You can smooth out the checkpoint
Adrian Moisey wrote:
> Hi
>
If I tail the logs, I see a steady stream of functions that took longer
then 5 seconds. But every now and then I see nothing for 3 minutes and
after that a whole bunch (about 20 - 30) queries all finishing at the
same second.
>>>
>>> Search this l
Hi
If I tail the logs, I see a steady stream of functions that took
longer then 5 seconds. But every now and then I see nothing for 3
minutes and after that a whole bunch (about 20 - 30) queries all
finishing at the same second.
Search this list for references to "checkpoints". If you run
Hi
If I tail the logs, I see a steady stream of functions that took
longer then 5 seconds. But every now and then I see nothing for 3
minutes and after that a whole bunch (about 20 - 30) queries all
finishing at the same second.
Search this list for references to "checkpoints". If you run
On Jan 17, 2008 12:50 AM, Adrian Moisey <[EMAIL PROTECTED]> wrote:
> Hi
>
> >> Search this list for references to "checkpoints". If you run
> >> vmstat/iostat for a bit you should see bursts of disk activity at
> >> those times.
> >
> > The most straightforward way to prove or disprove that the slo
We had the same situation, and did two things
1. Reduce checkpoint timeout
2. Reduce quantity of data going into database (nice if it's possible!)
1 alone wasn't enough to eliminate the delays, but it did make each delay small
enough that the user interface was only minimally affected. Previo
Hi
Search this list for references to "checkpoints". If you run
vmstat/iostat for a bit you should see bursts of disk activity at
those times.
The most straightforward way to prove or disprove that the slow queries
line up with checkpoints is to set to checkpoint_warning to a high value
(36
On Wed, 16 Jan 2008, Richard Huxton wrote:
Search this list for references to "checkpoints". If you run vmstat/iostat
for a bit you should see bursts of disk activity at those times.
The most straightforward way to prove or disprove that the slow queries
line up with checkpoints is to set to
On Jan 16, 2008 4:42 AM, Adrian Moisey <[EMAIL PROTECTED]> wrote:
> Hi
>
> I've noticed a strange pattern in our logs.
>
> We only log anything that takes longer then 5 seconds.
>
> If I tail the logs, I see a steady stream of functions that took longer
> then 5 seconds. But every now and then I s
Richard Huxton <[EMAIL PROTECTED]> writes:
> Adrian Moisey wrote:
>> If I tail the logs, I see a steady stream of functions that took longer
>> then 5 seconds. But every now and then I see nothing for 3 minutes and
>> after that a whole bunch (about 20 - 30) queries all finishing at the
>> same
Adrian Moisey wrote:
If I tail the logs, I see a steady stream of functions that took longer
then 5 seconds. But every now and then I see nothing for 3 minutes and
after that a whole bunch (about 20 - 30) queries all finishing at the
same second.
Search this list for references to "checkpo
Hi
I've noticed a strange pattern in our logs.
We only log anything that takes longer then 5 seconds.
If I tail the logs, I see a steady stream of functions that took longer
then 5 seconds. But every now and then I see nothing for 3 minutes and
after that a whole bunch (about 20 - 30) querie
14 matches
Mail list logo
