flush status;
show status like '%libraries%';
Variable_name	Value
Opened_plugin_libraries	0
select * from information_schema.all_plugins where plugin_library='ha_example.so';
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
EXAMPLE	0.1	NOT INSTALLED	STORAGE ENGINE	MYSQL_VERSION_ID	ha_example.so	1.8	Brian Aker, MySQL AB	Example storage engine	GPL	OFF	Experimental	0.1
UNUSABLE	3.14	NOT INSTALLED	DAEMON	MYSQL_VERSION_ID	ha_example.so	1.8	Sergei Golubchik	Unusable Daemon	GPL	OFF	Experimental	3.14.15.926
show status like '%libraries%';
Variable_name	Value
Opened_plugin_libraries	1
show plugins soname 'ha_example.so';
Name	Status	Type	Library	License
EXAMPLE	NOT INSTALLED	STORAGE ENGINE	ha_example.so	GPL
UNUSABLE	NOT INSTALLED	DAEMON	ha_example.so	GPL
show status like '%libraries%';
Variable_name	Value
Opened_plugin_libraries	2
show plugins soname like '%example%';
Name	Status	Type	Library	License
EXAMPLE	NOT INSTALLED	STORAGE ENGINE	ha_example.so	GPL
UNUSABLE	NOT INSTALLED	DAEMON	ha_example.so	GPL
daemon_example	NOT INSTALLED	DAEMON	libdaemon_example.so	GPL
three_attempts	NOT INSTALLED	AUTHENTICATION	dialog_examples.so	GPL
two_questions	NOT INSTALLED	AUTHENTICATION	dialog_examples.so	GPL
show status like '%libraries%';
Variable_name	Value
Opened_plugin_libraries	6
show plugins soname where library = 'ha_example.so';
Name	Status	Type	Library	License
EXAMPLE	NOT INSTALLED	STORAGE ENGINE	ha_example.so	GPL
UNUSABLE	NOT INSTALLED	DAEMON	ha_example.so	GPL
select variable_value > 10 from information_schema.global_status where variable_name like '%libraries%';
variable_value > 10
1
