Akonadi Database maintenance

[Martin Steigerwald <martin@lichtvoll.de>]

Hello.

I am just forwarding it for all users that are using KMail / KDEPIM.

I think you Akonadi shouldn´t require you to be a database admin,  but maybe 
my simple tips may be of some help to you. Usually MySQL will run even without 
being upgraded… however there are chances it will run *better* if you keep it 
up to date. And it will create less noise in the log.

Thank you,
Martin

----------  Weitergeleitete Nachricht  ----------

Betreff: Database maintenance
Datum: Mittwoch, 16. August 2017, 09:33:28 CEST
Von: Martin Steigerwald <martin@lichtvoll.de>
An: kdepim-users@kde.org

Hello.

Today I found again some errors in mysql.err, that some innodb stats table 
does not exist. There are wild help blog posts available to create those 
manually by pasting page long mysql create statements into your mysql client. 
Don´t.

In my case the errors didn´t prevent startup of Akonadi, but I still wanted to 
clean MySQL log file again. In my company accoun even the complete mysql 
database was missing… I don´t want to know anything about why that is the 
case. It might be that I messed it up at some time… even with a time machine I 
wouldn´t know to what time to go back to exactly check what happened there.

Anyway, in case you have messages like missing tables in mysql or information 
database and things like that, or even on any major MySQL or in my case 
MariaDB update, you can just run:

mysql_upgrade --socket ~/.local/share/akonadi/socket-merkaba/mysql.socket

while MySQL is running. Says: While Akonadi is running.

Of course to complete the maintenance you can also run:

akonadictl fsck

and

akonadictl vacuum

(later only if you have enough free space)


In my point of view Akonadi should handle at least the mysql_upgrade thing 
automatically (or not use a RDMS). It shall not require the user to be a 
database admin.

Of course it can also help to document the above in user wiki. Feel free to 
copy&paste if you go about it.

Thanks,
-- 
Martin

-------------------------------------------------------------
-- 
Martin