Thursday, August 20, 2009
Falcon - MySQL Storage Engine
Falcon - MySQL Storage EngineThe 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
Subscribe to:
Post Comments
(
Atom
)
2 comments :
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.
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.
Post a Comment