Bug 3855

Summary:	akonadi's mysqld uses more memory than mysql
Product:	Mageia	Reporter:	AL13N <alien>
Component:	RPM Packages	Assignee:	John Balcaen <balcaen.john>
Status:	RESOLVED WONTFIX	QA Contact:
Severity:	normal
Priority:	Normal	CC:	alien, balcaen.john
Version:	Cauldron	Keywords:	Triaged
Target Milestone:	---
Hardware:	All
OS:	Linux
URL:	https://answers.launchpad.net/maria/+question/162766
Whiteboard:
Source RPM:	akonadi	CVE:
Status comment:

Description AL13N 2011-12-22 21:46:03 CET

with tuning, we can drop this:

according to upstream:

[mariadb]
key_buffer_size = 1m # (as it's not used; no aria and no myisam)
aria_pagecache_buffer_size = 4m (as aria is used for tmp tables)
aria_sort_buffer_size = 4m (same as above)

it's in a separate section, so that mysql would have no issue with it, if we were later to use mysql...

AL13N 2011-12-22 21:47:44 CET

CC: (none) => alien

Comment 1 AL13N 2011-12-22 21:49:01 CET

correction:

[mariadb]
key_buffer_size = 128k # (as it's not used; no aria and no myisam)
aria_pagecache_buffer_size = 4m (as aria is used for tmp tables)
aria_sort_buffer_size = 4m (same as above)

(so this can be appended to the mysql.conf that gets "generated" for .local

Comment 2 Manuel Hiebel 2011-12-22 22:03:33 CET

Hi, thanks for reporting this bug.
Should this bug not be reporting upstream ?

Keywords: (none) => Triaged
Assignee: bugsquad => balcaen.john

Comment 3 AL13N 2011-12-22 23:06:22 CET

i have no idea, i was maybe planning on maybe doing this myself, if mikala agreed...

Comment 4 AL13N 2011-12-23 00:05:35 CET

ok, after more discussions it didn't seem to have much effect (3MB), so we should go for:

[mariadb]
key_buffer_size = 8m
aria_pagecache_buffer_size = 8m
aria_sort_buffer_size = 8m

Comment 5 John Balcaen 2011-12-25 16:27:34 CET

Ok without thoses lines mysqld is using 146 692 k & 7012 of shared memory
against 124 576 & 7240 of shared memory when using specific maria db.
However it seems that mysqld is now using a little more CPU than before thoses configuration settings.

CC: (none) => balcaen.john

Comment 6 AL13N 2011-12-26 01:32:56 CET

you think we should leave it at default settings? or do you think your case is so advanced that we should still keep these and let the "advanced" users tune it?

it's your call...

if you want to get this tuned to perfection, i'm pretty sure upstream will be quite accomodating... (there are some people there who will go to the kB of memory usage)

Comment 7 John Balcaen 2012-05-05 19:31:44 CEST

Yep we should leave it as default upstream & eventually report it upstream (akonadi) to have their opinion.
Closing as wontfix.

Status: NEW => RESOLVED
Resolution: (none) => WONTFIX