Summary: | MySQL tuning: adaption of MySQL tuning options for larger accounts | ||
---|---|---|---|
Product: | [Frameworks and Libraries] Akonadi | Reporter: | Martin Steigerwald <martin.steigerwald> |
Component: | server | Assignee: | kdepim bugs <kdepim-bugs> |
Status: | REPORTED --- | ||
Severity: | wishlist | CC: | dvratil, Martin |
Priority: | NOR | ||
Version: | 4.12 | ||
Target Milestone: | --- | ||
Platform: | Debian unstable | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: | |||
Attachments: | default configuration as of Akonadi 1.11.0-1 debian package |
Description
Martin Steigerwald
2014-03-26 11:53:57 UTC
Created attachment 85762 [details]
default configuration as of Akonadi 1.11.0-1 debian package
I will try my setups with with default configuration for today for a while, and then raise some values to try to get a comparison.
I think mysqltuner recommendations (>1 GiB of innodb buffer pool size) are too high. It seems it recommends adjusting to actual data size in database, which would only be suitable if all of the data is accessed often. What is the amount data Akonadi accesses frequently? Are there any experiences with that? I bet it depends highly on how the user uses it and the amount of mails in a single folder to be synchronized. See [Kde-pim] Akonadi MySQL backend: tuning for larger accounts or switching to MariaDB with a different storage engine? http://lists.kde.org/?l=kde-pim&m=139583561813493&w=2 for further discussion. Actually so far I found no trace as to default InnoDB buffer size being a problem. I cannot prove any issues with default InnoDB buffer size, instead I found KMail being blocked out on mail indexing, so feel free to close. I cannot in Status drop down. See the mail thread mentioned in last comment. Scratch that: I saw some small buffer pool miss rate: mysql> SHOW ENGINE INNODB STATUS\G; […] ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 85852160; in additional pool allocated 0 Dictionary memory allocated 103892 Buffer pool size 5120 Free buffers 0 Database pages 4871 Old database pages 1778 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 659333, not young 0 3302.78 youngs/s, 0.00 non-youngs/s Pages read 619033, created 84, written 1204 3191.25 reads/s, 0.53 creates/s, 10.80 writes/s Buffer pool hit rate 977 / 1000, young-making rate 24 / 1000 not 0 / 1000 Pages read ahead 79.79/s, evicted without access 21.00/s, Random read ahead 0.00/s LRU len: 4871, unzip_LRU len: 0 I/O sum[267946]:cur[0], unzip sum[0]:cur[0] Another example: ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 85852160; in additional pool allocated 0 Dictionary memory allocated 103892 Buffer pool size 5120 Free buffers 0 Database pages 4942 Old database pages 1804 Modified db pages 10 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1076283, not young 0 10570.21 youngs/s, 0.00 non-youngs/s Pages read 1015530, created 110, written 1673 10471.76 reads/s, 0.50 creates/s, 10.00 writes/s Buffer pool hit rate 965 / 1000, young-making rate 36 / 1000 not 0 / 1000 Pages read ahead 479.76/s, evicted without access 78.46/s, Random read ahead 0.00/s LRU len: 4942, unzip_LRU len: 0 I/O sum[88144]:cur[7656], unzip sum[0]:cur[0] So a little raising for my setup might be beneficial. This as I saw akonadi maildir agent and MySQL at 100% CPU usage for a while after restarting Akonadi due to bug with retrieving Items I report in a moment as I disabled Nepomuk mail indexing, downloaded mail and then quitted it cause maildir agent crashed. This bug: Bug 332653 - After mail receive on filtering: Unable to retrieve item from resource: NO ImapParserException: Unable to read more data Thank you for the bug report. As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists. If this bug is no longer persisting or relevant please change the status to resolved. |