An Entrepreneur, Coach, IT Consultant, Strategic Adviser, and a Traveler craving to explore and contribute to forming a better society.

Thursday, August 20, 2009

Falcon - MySQL Storage Engine

2 comments :
Falcon - MySQL Storage Engine

The Falcon database storage engine is for large volume data while improving greater performance on sql queries


Though its a new storage engine for msyql, it still supports transaction and logging functionality.

Table definitions are stored in .frm files like other MySQL engines

Two new files are created by Falcon for every table and they are log files.

The log files are named as follows:
  • falcon_master.fl1
  • falcon_master.fl2

One can use "ENGINE=Falcon" option within the "CREATE TABLE" statement to create a table using Falcon storage engine

To create a Falcon type of mysql table, use the following syntax:

mysql> create table table_name (columns) ENGINE=FALCON


To check whether blackhole engine is existing in your Database Server, issue the follwing command:

mysql> SHOW VARIABLES LIKE 'have_falcon_engine';
+--------------------+----------+
| Variable_name | Value |
+-----------------------+-------+
| have_falcon_engine | Yes |
+--------------------+----------+
1 row in set (0.00 sec)

To check the available storage engines, issue the following command:
mysql> show engines;

Features of Falcon Database Storage Engine:

  • Falcon storage engine has a large storage of 512ZB.
  • Falcon storage engine supports transactions
  • Falcon storage engine doesn't support hash indexes
  • Falcon storage engine supports data cache/caching
  • Falcon Database Engine is available for the 32-bit Windows and 32-bit or 64-bit Linux operating systems

For more information, pls visit: http://dev.mysql.com/doc/refman/6.0/en/se-falcon.html

2 comments :

Ann said...

By default, Falcon creates five files for each installation: falcon_master.fts, falcon_user.fts, falcon_temporary.fts, falcon_master.fl1 and falcon_master.fl2. The *.fts files are falcon tablespaces. Falcon_master.fts contains the metadata for all falcon tables and databases defined for the installation. Falcon_user.fts contains all the user defined tables.

MySQL creates one .frm file per table that contains the MySQL metadata for that table.

Falcon data can be placed explicitly by creating additional .fts files and assigning specific tables to those files.

Ann said...

By default, Falcon creates five files for each installation: falcon_master.fts, falcon_user.fts, falcon_temporary.fts, falcon_master.fl1 and falcon_master.fl2. The *.fts files are falcon tablespaces. Falcon_master.fts contains the metadata for all falcon tables and databases defined for the installation. Falcon_user.fts contains all the user defined tables.

MySQL creates one .frm file per table that contains the MySQL metadata for that table.

Falcon data can be placed explicitly by creating additional .fts files and assigning specific tables to those files.