[kdepim-users] Frequent coruptions of data base. Any remedies?

[Kevin Krammer]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 190 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20111112/8641f6f3/attachment.sig>
-------------- next part --------------
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users