For me setting:

innodb_flush_log_at_trx_commit = 0

in /etc/my.cnf helped the most. Older versions of mysql had this set this way.

See here: http://dev.mysql.com/doc/refman/4.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit

Check for lots of writes using 'iostat -x 1', my disks went from 100% busy to almost idle.

Regards,
Senax

Thanks!

That seems to have done the trick =)

Hi,

I've installed a newly downloaded urd and have some problems updating newsgroups. This is a new install and I let it create the tables automatically.

urdd: WARNING Database problem: (1690) mysqli error: [1690: BIGINT UNSIGNED value is out of range in '(-(243) + "urddb"."queueinfo"."ETA")'] in EXECUTE("UPDATE queueinfo SET "ETA"=((-243 + "ETA") / 2), "progress"='100', "comment"='37 articles/s - total 1000 articles', "lastupdate"='1325973151' WHERE "ID"='451'")

 urdd: ERROR Error while updating alt.binaries.hdtv.x264: Could not execute SQL query "UPDATE queueinfo SET "ETA"=((-243 + "ETA") / 2), "progress"='100', "comment"='37 articles/s - total 1000 articles', "lastupdate"='1325973151' WHERE "ID"='451'" mysqli error: [1690: BIGINT UNSIGNED value is out of range in '(-(243) + "urddb"."queueinfo"."ETA")'] in EXECUTE("UPDATE queueinfo SET "ETA"=((-243 + "ETA") / 2), "progress"='100', "comment"='37 articles/s - total 1000 articles', "lastupdate"='1325973151' WHERE "ID"='451'")


It seems a bit odd to add an integer to a string? ( -243 + "ETA")?

Ideas on how to fix this?

Thanks!

Senax