What does MariaDB’s user feedback feature report?
I was curious what information MariaDB’s “phone home” user feedback plugin sends. (It works on more than just MariaDB, by the way.)
It’s easy enough to find out: just load the plugin, then select from the INFORMATION_SCHEMA.FEEDBACK table. This returns a lot of rows that are obviously the status counters and variables, as well as the plugins loaded in the server. A quick exclusion join will eliminate those, and the result on my laptop is this:
select f.* from feedback as f
left outer join global_variables as v on f.variable_name = v.variable_name
left outer join global_status as s on f.variable_name = s.variable_name
left outer join plugins as p on f.variable_name = p.plugin_name
where s.variable_name is null and v.variable_name is null and p.plugin_name is null;
+--------------------+--------------------------------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+--------------------+--------------------------------------+
| Cpu_count | 2 |
| Mem_total | 4186529792 |
| Uname_sysname | Linux |
| Uname_release | 2.6.41.1-1.fc15.i686.PAE |
| Uname_version | #1 SMP Fri Nov 11 21:43:42 UTC 2011 |
| Uname_machine | i686 |
| Uname_distribution | fedora: Fedora release 15 (Lovelock) |
+--------------------+--------------------------------------+
This actually isn’t all, though. If you check the output of SHOW VARIABLES you’ll see an extra few rows, one of which is this:
+---------------------+------------------------------+
| Variable_name | Value |
+---------------------+------------------------------+
| feedback_server_uid | xlGYjFKJ0ivpSWAktGglpEgVTq8= |
+---------------------+------------------------------+
I’ll have to look into how that’s calculated. It might be useful.
If you want to use the values, but not send anything, you can install the plugin and configure an empty feedback_url. You’ll get I_S.FEEDBACK table, but no sender thread.
Sergei Golubchik
4 Dec 11 at 7:08 am