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