[kmail2] [Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 Martin Steigerwald changed: What|Removed |Added CC||mar...@lichtvoll.de Status|NEEDSINFO |RESOLVED --- Comment #11 from Martin Steigerwald --- Thanks, Thomas. Closing. Reopen when it happens again. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 Thomas McGuire changed: What|Removed |Added Status|NEW |NEEDSINFO Resolution||WORKSFORME --- Comment #10 from Thomas McGuire 2010-04-12 18:50:34 --- Doesn't happen right now, I'll reopen when it happens again. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #9 from Thomas McGuire 2010-02-03 14:01:30 --- As mentioned, just displaying the parttable in Akonadiconsole is also slow: # u...@host: [thomas] @ localhost [] # Query_time: 27 Lock_time: 0 Rows_sent: 28918 Rows_examined: 28918 SELECT `id`, `pimItemId`, `name`, `data`, `datasize`, `version`, `external` FROM parttable; -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #8 from Thomas McGuire 2010-02-03 13:05:45 --- The query from comment #6 is executed twice when selecting a folder, doubling the delay. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #7 from Thomas McGuire 2010-02-03 12:59:13 --- > I can reproduce the problem again, after adding an IMAP resource: The folder I opened was a local maildir folder, not an IMAP folder. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #6 from Thomas McGuire 2010-02-03 12:58:21 --- I can reproduce the problem again, after adding an IMAP resource: # Time: 100203 12:56:26 # u...@host: [trunk] @ localhost [] # Query_time: 155 Lock_time: 0 Rows_sent: 33 Rows_examined: 968385 SELECT PimItemTable.id, PartTable.name, PartTable.data, PartTable.version, PartTable.external FROM PimItemTable, PartTable WHERE ( PimItemTable.id = PartTable.pimItemId AND ( PartTable.name IN ( 'COLLECTIONID', 'PLD:HEAD' ) ) AND ( PimItemTable.id >= 1 ) AND collectionId = 15 ) ORDER BY PimItemTable.id ASC; -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #5 from Thomas McGuire 2010-02-03 12:48:07 --- Torgny made a log at http://www.nyblom.org/pub/kde/mysql.slow, but I don't think it shows the problem - the query of comment#2 is not in there (grep for "ORDER BY Pimitemtable.id"). -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #4 from Thomas McGuire 2010-02-03 12:28:24 --- For some strange reason, the problem disappeared all of a sudden. Where "all of a sudden" means after disabling some resources, restarting Akonadi a couple of times and even killing Akonadi + mysql once or twice. For tracking down this problem, enabling the MySQL slow log might help. See $KDEDIR/share/config/akonadi/mysql-global.conf, the settings log_slow_queries and long_query_time. The slow log will appear at $HOME/.local/share/akonadi/db_data/mysql.slow -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #3 from Thomas McGuire 2010-02-02 22:18:41 --- > "Akonadiconsole doesn't have this problem." Not sure if that is really the case, I'll check again. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #2 from Thomas McGuire 2010-02-02 22:14:25 --- The problem seems to be the part query in FetchHelper::parseStream(). This is an example debug output, with some timing info: 2010-02-02T21:57:55 Executing part query. SELECT PimItemTable.id, PartTable.name, PartTable.data, PartTable.version, PartTable.external FROM PimItemTable, PartTable WHERE ( PimItemTable.id = PartTable.pimItemId AND ( PartTable.name IN ( :0, :1 ) ) AND ( PimItemTable.id >= :2 ) AND collectionId = :3 ) ORDER BY PimItemTable.id ASC ":0" QVariant(QString, "COLLECTIONID") ":1" QVariant(QString, "PLD:HEAD") ":2" QVariant(qlonglong, 1) ":3" QVariant(qlonglong, 18882) 2010-02-02T21:58:23 Part query done, now building response. Executing that query in the DB console has the same slowness. Displaying the part table in the DB browser also takes about a minute here, with ~100k entries in there. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 --- Comment #1 from Thomas McGuire 2010-01-26 18:17:55 --- It seems that every item fetch job that fetches the headers takes insanely long. The same happens in KMailCVT, which fetches the headers to get the message IDs for duplicate checking. mysql uses 120% CPU during that time, according to top. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 Thomas McGuire changed: What|Removed |Added Priority|HI |VHI -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 Thomas McGuire changed: What|Removed |Added Severity|major |normal -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 Thomas McGuire changed: What|Removed |Added Keywords||akonadi-ports-regression -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 223439] Item listing for folders slow
https://bugs.kde.org/show_bug.cgi?id=223439 Thomas McGuire changed: What|Removed |Added Priority|NOR |HI Blocks||223438 Severity|normal |major -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs