On Sat, 17 Jun 2006, Tracy R Reed wrote:

> I am running SQLite3
> for the db.

SQLite is only suitable for test setups.

Do yourself a big favour and move to MySQL or Postgres.

> I set
> PRAGMA synchronous = OFF; on the db just for kicks but it seems to have
> had no effect.  top says 50% of the cpu is in IO wait and the rest is
> idle with only a few percent being used for any real work. Typical
> iostat looks like:

If you're in 50% IOwaits, then something is constantly fsynching and it's 
most likely to be the database.

> How on earth could it be writing so much more than it is reading? That
> is quite puzzling. If I strace the bacula-fd or bacula-sd processes they
> are just sitting in a select. I never see them doing anything else.

That's because they are waiting for another process....

AB



_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to