Debian Codegraph @

mysql-test/suite/plugins/r/show_all_plugins.result

raw
1 flush global status;
2 show status like '%libraries%';
3 Variable_name Value
4 Opened_plugin_libraries 0
5 select * from information_schema.all_plugins where plugin_library='ha_example.so';
6 PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE PLUGIN_TYPE_VERSION PLUGIN_LIBRARY PLUGIN_LIBRARY_VERSION PLUGIN_AUTHOR PLUGIN_DESCRIPTION PLUGIN_LICENSE LOAD_OPTION PLUGIN_MATURITY PLUGIN_AUTH_VERSION
7 EXAMPLE 0.1 NOT INSTALLED STORAGE ENGINE MYSQL_VERSION_ID ha_example.so 1.15 Brian Aker, MySQL AB Example storage engine GPL OFF Experimental 0.1
8 UNUSABLE 3.14 NOT INSTALLED DAEMON MYSQL_VERSION_ID ha_example.so 1.15 Sergei Golubchik Unusable Daemon GPL OFF Experimental 3.14.15.926
9 show status like '%libraries%';
10 Variable_name Value
11 Opened_plugin_libraries 1
12 show plugins soname 'ha_example.so';
13 Name Status Type Library License
14 EXAMPLE NOT INSTALLED STORAGE ENGINE ha_example.so GPL
15 UNUSABLE NOT INSTALLED DAEMON ha_example.so GPL
16 show status like '%libraries%';
17 Variable_name Value
18 Opened_plugin_libraries 2
19 show plugins soname like '%example%';
20 Name Status Type Library License
21 EXAMPLE NOT INSTALLED STORAGE ENGINE ha_example.so GPL
22 UNUSABLE NOT INSTALLED DAEMON ha_example.so GPL
23 daemon_example NOT INSTALLED DAEMON libdaemon_example.so GPL
24 example_key_management NOT INSTALLED ENCRYPTION example_key_management.so GPL
25 three_attempts NOT INSTALLED AUTHENTICATION dialog_examples.so GPL
26 two_questions NOT INSTALLED AUTHENTICATION dialog_examples.so GPL
27 show status like '%libraries%';
28 Variable_name Value
29 Opened_plugin_libraries 7
30 show plugins soname where library = 'ha_example.so';
31 Name Status Type Library License
32 EXAMPLE NOT INSTALLED STORAGE ENGINE ha_example.so GPL
33 UNUSABLE NOT INSTALLED DAEMON ha_example.so GPL
34 select variable_value > 10 from information_schema.global_status where variable_name like '%libraries%';
35 variable_value > 10
36 1