[Akonadi] [Bug 332626] MySQL tuning: adaption of MySQL tuning options for larger accounts

[Martin Steigerwald]

https://bugs.kde.org/show_bug.cgi?id=332626

--- Comment #5 from Martin Steigerwald <Martin at Lichtvoll.de> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.