Comment 17 for bug 229745

Revision history for this message
Alexander Sack (asac) wrote : Re: [Bug 229745] Re: after fix for #215728 - Committing to urlclassifier3.sqlite still causes excessive CPU usage and disk I/O (the 2nd)

On Sat, Jun 14, 2008 at 12:43:49PM -0000, R (Chandra) Chandrasekhar wrote:
> My places.sqlite file has grown to 12107776 bytes and there is still
> periodic loss of responsiveness with high CPU usage and concentrated
> I/O.
>
> My urlclassifier3.sqlite file is growing only slowly at is 54878208
> bytes and does not seem to be the problem.
>
> Perhaps this blog explains what I am experiencing:
>
> Christopher Blizzard » Blog Archive » system components, fsync and distribution-specific changes: a cautionary tale
> http://www.0xdeadbeef.com/weblog/?p=368
>
> I checked my libsqlite3-0 and found it was version was 3.4.2-2.

This isn't an issue in our builds. we have all the patches in rc1 that
were about those fsync issues and we dont use system-sqlite, so we are
not affected by a version mismatch causing performance.

>
> I have now used prevu to compile version3.5.9-2~8.04prevu1. I do not
> know if it will help because the firefox I am using is already compiled
> and version 3.0~rc1+nobinonly-0ubuntu0.8.04.1.
>
> But I am sure that it is places.sqlite that is causing loss of
> responsiveness.

Why are you sure about this?

 - Alexander