• The Hyperstage storage engine (named Brighthouse) should always be used when working with Hyperstage data. This is the default setting created when using the installer.
• To view all available engines, enter the following command:

  mysql> show engines;

The following information is displayed at the command prompt. In this example, MyISAM is shown as the default storage engine. You can combine the usage of different storage engines but you should avoid joining across storage engines as this can result in sub-optimal performance due to the use of the MySQL query engine. However, it can be quite useful in some cases to store query results in memory or MyISAM tables and do further manipulations of results.