Re: kmail migration akonadi database Mysql to Sqlite3
Hi Philippe, hi.
Please do not use HTML. Additionally work for plain text formatting when I
reply to you.
phil-deb1.merlin@laposte.net - 04.03.25, 15:27:11 Mitteleuropäische
Normalzeit:
> Faced with slowdowns sometimes reaching almost a minute of very
> unpleasant operation of Kmail which I perhaps wrongly attribute to
> Akonadi and its Mysql
Do you use POP3 and local maildir storage?
I had these as well. With SQLite3 it is much better, much faster. But
occasionally I still have such a strange pause.
> database, I read in this list that Akonadi with a Sqlite3 database is
> much faster. I would like to migrate my Mysql database to Sqlite3. the
> planned procedure not working see Debian Bug 1098891# not wanting to
> abandon Kontact I have been an old user since 2003, 22 years. I thought
That is even longer than me.
> of a solution, I would like you to tell me what you think.
> Remove pim, kontact, kmail, akonadi.
That is the brute force approach.
> Delete the akonadi Mysql database.
>
> Reinstall Kontact, Kmail, Pim, akonadi.
>
> At this time configure akonadi with Sqlite3 as a database.
>
> In Kontact import messages that were stored in a directory.
I'd not really import messages. It is enough to point a maildir resource
to the location where the old mails are… or… move them into the new
location.
However in case you just remove the Akonadi MySQL database, the maildir
resource configuration is not lost. So it will pick up your old mails
automatically anyway.
However… wherever you reference mail folders in KMail configuration,
including filters these references are very likely to be wrong. They are
by database ID and that will change.
I already described that I migrated without the migrator. I basically just
deleted the old database and switched configuration in ~/.config/
akonadiserverrc to SQLite:
% cat .config/akonadi/akonadiserverrc
[…]
[%General]
Driver=QSQLITE
I think that will be enough. It will automatically choose the location of
the database file on first start.
*Before* that however I exported all my local mail filters to a file.
Then I deleted those.
I kept all other configuration.
I stopped akonadi: "akonadictl stop".
I removed old database.
I did not remove and reinstall KDEPIM. It is not necessary.
I changed to SQLite3.
I did "akonadictl start" in a command line to see whether database
creation works and so on.
I started KMail.
I reimported all local mail filters.
I reviewed every reference to a folder in KMail configuration.
Like within my identities, POP3, IMAP and SMTP configuration.
That worked for me.
I do not really have the time to give support. But these were the basic
steps I did. I also wrote about it before already.
> It's a shame that I have to do this gymnastics because the planned
> procedure is blocked from the start and in my opinion the specialists
> that you are will have no difficulty in correcting bug 1098891#.
Sorry, that is not how it works.
Debian Qt/KDE developers package KDEPIM. Many of them are not upstream
developers. If you read my other mails carefully, you know that I already
suggested to check whether there is an upstream issue and if not report
one.
Again and again and again: Most of them, if not all of them are doing all
of this work in their free time. For me that means: I am not in a position
to place demands on them.
But I could help. By checking for upstream bug report, doing one if there
is none and I have installed most recent versions in Debian – they are up
to date at the moment –, and providing necessary details, including
ideally a GDB backtrace of the crash.
Best,
--
Martin
Reply to: