On Mon, May 21, 2007 at 04:42:02PM +0300, Marko Mäkelä wrote:
> 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.
Is there any way around this? Could a storage engine plugin somehow
automatically install all INFORMATION_SCHEMA plugins that the engine
implements? Sort of adding virtual rows to the mysql.plugin table?
I fear it would be cumbersome for users to issue multiple INSTALL PLUGIN
statements when installing an InnoDB plugin. (We are working on
exporting the output of SHOW ENGINE INNODB STATUS via INFORMATION_SCHEMA
tables.)
Marko
