Stay Curious!

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.

Posted on Sat, Dec 3, 2011. Approximately 300 Words.

Databases