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      |             |
| 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.

See Also

I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and lots of open-source software for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB. More about me.