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 checkpoint_warning to a high value
(3600 should work), which should log every checkpoint, and then see if
they show up at the same time in the logs.
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD