Within Falcon, all data within one database is stored within a single tablespace, which in turn is stored within a single file within the MySQL directory structure. A single Falcon database will create three main files. One file contains the Falcon data and will be stored in a file with the name of the Falcon database with the extension .fts. For example, Falcon tables defined within the database test will be stored within the file test.fts within the main MySQL data directory.

Two further files contain the on-disk copy of the Falcon serial log. These are also created within the realm of the corresponding database. In a future release, you will be able to specify an alternate location for these log files. So with the preceding example data file test.fts the log files will be named test.fl1 and test.fl2.

Table definitions are, as with the other MySQL engines, stored within a .frm file within a database specific directory. For example, the table falcontest within the test database will create the table definition file falcontest.frm within the directory test.

When creating a table within a MySQL database where the corresponding Falcon tablespace file does not exist, it will automatically be created with the Falcon data file and log files.