Re: Frequent coruptions of data base. Any remedies?

On Saturday, 2011-11-12, Stephan Diestelhorst wrote:

> This seems to be MySQL / InnoDB's fault. According to
> http://www.chriscalender.com/?tag=innodb-power-failure their database
> setup is really flakey and while they see that they could make it more
> stable, they didn't choose to do so. :(
> 
> I am currently testing with the suggested settings of
> 
> sync_binlog = 1
> innodb_flush_log_at_trx_commit = 1
> 
> in .local/share/akonadi/mysql.conf
> 
> Is there a reason why they are not default?

Most likely nobody knew about these settings.
One would assume that the whole point of transactions and bin logs would be to 
ensure data integrity.

> If my email were POP, I
> would have lost considerable amounts of mail by this.

How so?

Cheers,
Kevin
-- 
Kevin Krammer, KDE developer, xdg-utils developer
KDE user support, developer mentoring

_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iD8DBQBOvsWgnKMhG6pzZJIRAp07AJ9zFhUVP5wL8oRQ/DfMjviVQaXdpQCeKCId
tftI0f4EAHVD+fGre5wxf+0=
=yIF9
-----END PGP SIGNATURE-----