MariaDB (MySQL)usage statistics wanted - your help is needed

[doktor5000]

Forwarding a mail from mageia-discuss mailing list*, AL13N, Mageia's MariaDB maintainer wants to collect usage statistics:

Hi,

As you all likely know, at mageia we replaced MySQL with MariaDB.

When MariaDB devs told me that it seemed their biggest market was Windows, I
was really astounded.

They then referred me to the feedback plug and this statistics page:
http://mariadb.org/feedback_plugin/stats/os/

The explanation is quite simple:
- Windows users need to download the version from MariaDB site (which has
feedback enabled by default).
- Linux users can get it from MariaDB site, or from their own distro. (and
those versions don't have feedback enabled by default at all...) (for good
reason).

Still, the numbers are completely wrong, and therefor, i urge all of you to
load the feedback plugin for all servers you manage! so that these statistics
can better influence both MariaDB and Mageia.

How to enable feedback plugin? easy:

1. install mariadb-feedback package
2. load it in your config file, by adding it to your plugin-load line:

(in /etc/my.cnf )

plugin_dir=/usr/lib64/mysql/plugin
plugin-load=ha_archive.so;ha_blackhole.so;ha_federatedx.so;feedback.so

3. if possible, if you're using KDE, your akonadi also uses mariadb. so you
can add this to your akonadi mariadb config file too, in mysqld section:

(in ~/.local/share/akonadi/mysql.conf )

[mysqld]
plugin_dir=/usr/lib64/mysql/plugin
plugin-load=feedback.so

then restart akonadi with (akonadictl restart)



thanks in advance,

AL13N (mageia mariadb maintainer)

*: https://www.mageia.org/pipermail/mageia ... 08349.html

So please follow his advice, and enable the feedback plugin in your MariaDB/MySQL installations,
so that MariaDB folks and Mageia can benefit from correct real-world values.

[filip]

I did both. But then I tried to restart akonadi I got this:

Code: Select all

# akonadictl restart
D-Bus session bus is not available!
"[
0: akonadictl(_Z11akBacktracev+0x36) [0x805f146]
1: akonadictl() [0x805f400]
2: [0xffffe400]
3: [0xffffe424]
4: /lib/i686/libc.so.6(gsignal+0x4f) [0xb70d5a7f]
5: /lib/i686/libc.so.6(abort+0x175) [0xb70d74a5]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8a) [0xb747e6ba]
7: akonadictl(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x805dd08]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xb7527969]
9: /usr/lib/libQtCore.so.4(+0x11275d) [0xb753475d]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb753e2be]
11: akonadictl(_ZN13AkApplication4initEv+0x109) [0x8056d39]
12: akonadictl(main+0x8c) [0x80516dc]
13: /lib/i686/libc.so.6(__libc_start_main+0xf3) [0xb70c23e3]
14: akonadictl() [0x80533e1]
]                                                                                                                                                       
"

After upgrade to mga2 I erased my /home/user/.kde4 config. Any suggestions?

EDIT:
Solution is simple. Akonadi need to be restarted as user. Very logical but not obvious .

[doktor5000]

Please, this thread is not about Akonadi support or troubleshooting. Please use an existing Akonadi thread for that, or open a new one. Or did Akonadi work properly before enabling the feedback plugin?

[jtmh]

Done!

But for the 3rd part, if the Mageia system is 32-bit (i586), the plugin_dir should be modified to /usr/lib/mysql/plugin, that is,

Code: Select all

plugin_dir=/usr/lib/mysql/plugin

Forwarding a mail from mageia-discuss mailing list*, AL13N, Mageia's MariaDB maintainer wants to collect usage statistics:

3. if possible, if you're using KDE, your akonadi also uses mariadb. so you
can add this to your akonadi mariadb config file too, in mysqld section:

(in ~/.local/share/akonadi/mysql.conf )

[mysqld]
plugin_dir=/usr/lib64/mysql/plugin
plugin-load=feedback.so

then restart akonadi with (akonadictl restart)

[doktor5000]

Done!

But for the 3rd part, if the Mageia system is 32-bit (i586), the plugin_dir should be modified to /usr/lib/mysql/plugin, that is,

(in ~/.local/share/akonadi/mysql.conf )

[mysqld]
plugin_dir=/usr/lib64/mysql/plugin

Yep, good catch. Was also written on mailing list, and rather obvious

[alien]

alas, There was apparently a feedback plugin bug . but together with mariadb people we found the bugfix, and have submitted mariadb-5.5.25-2.mga2 in updates_testing.

see https://bugs.mageia.org/show_bug.cgi?id=6922 .

Can any of you update and test this and mention that on that QA bug report? so that this update can be validated?

thanks in advance

[alien]

As someone pointed out correctly, plugin_dir does not need to be set for akonadi users. I tested this out and it does work with only adding

plugin-load=feedback.so

to the [mysqld] section.

on a related note, there's a minor bug in the feedback reporting, which is fixed by this update: if people can update their mariadb packages from updates_testing and add a comment on the bug report, so this bug can be validated, that would be nice:

https://bugs.mageia.org/show_bug.cgi?id=6922

thanks in advance