Re: INFORMATION_SCHEMA_PLUGIN ignored for dynamic plugins?

[Marko Mäkelä]

On Mon, May 21, 2007 at 01:25:53PM +0300, Marko Mäkelä wrote:
> Hi all,
> 
> I have created two INFORMATION_SCHEMA pseudo-tables for exporting
> some InnoDB statistics.  These tables are available to the SQL interpreter
> when InnoDB is linked statically to MySQL, but not when it is loaded as
> a dynamic plugin.  Is this a known problem, or perhaps a bug in my code?

Thanks to the advice I got on #mysql-dev at freenode.net, I understood
that I will have to invoke INSTALL PLUGIN on every entity named inside
the mysql_declare_plugin() array.  I was pointed to this example code
that implements two INFORMATION_SCHEMA plugins within one library:

http://www.markleith.co.uk/?p=18

> {
>   MYSQL_INFORMATION_SCHEMA_PLUGIN,
>   &innobase_stat_zip,
[...]
> },
> {
>   MYSQL_INFORMATION_SCHEMA_PLUGIN,
>   &innobase_stat_zip,

I wonder if it is okay to have both elements point to the same
structure, innobase_stat_zip:

static struct st_mysql_information_schema innobase_stat_zip=
{ MYSQL_INFORMATION_SCHEMA_INTERFACE_VERSION };

	Marko