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