Hi All

MySQL allows pluggable storage engines. Is it possible to plug in infobright storage engine to my current MySQL installation or do I need to do a separate install of Infobright thus creating another instance of MySQL?

Thanks
Harsh

Hi Harsh,

You do need to install Infobright separately.  Infobright uses it’s own SQL optimizer and compression/decompression routines - MySQL’s optimizer is geared towards row based databases and Infobright takes a columnar approach.

You can have MyISAM installed within the Infobright instance, and utilize MyISAM tables.  However, this will result in Infobright using the MyISAM optimizer (it comes with the Infobright installation) rather than the Infobright SQL optimizer, and the resulting query times will be slower.

Thanks John for your quick response.

I just copied my MyISAM data files to the Infobright data directory and I can now see both the MyISAM database and Infobright database. I do not want to run 2 instances of MySQL. I did not copy anything else.

Will Infobright use the MyISM optimizer for both(MyISAM and Infobright)  databases or will it use Infobright optimizer for BRIGHTHOUSE engine and MyISAM optimizer for MyISAM engine?

Thanks
Harsh

Hi Harsh,

I haven’t tried copying the files in.  I would be interested in your experiences!  What I have done is created tables within Infobright that have an ENGINE=MYISAM, and then populated them.

Some thoughts on when the IB optimizer will be used versus the MySQL optimizer:

If you query against a non-IB table, the MySQL optimizer will be used.
If you query against an IB and a non-IB table, the MySQL optimizer will be used.
If you query against an IB table, or multiple IB tables, then the Infobright optimizer will be used, unless you are using functions that have not yet been optimized for Infobright (there’s other posts regarding this in the forums).

When your query runs, you can tell if it goes to the MySQL optimizer if you see a warning count greater than zero returned, and if you issue a SHOW WARNINGS you should see a message indicating that the MySQL optimizer was used.

I hope this helps.

John

Copying files worked like a charm. Now I can see both MyISAM and IB databases in the same instance.

Great to hear!

Thanks for trying this out.