InnoDB Website

Embedded Features

Embedded InnoDB provides all the performance and reliability, features and functions and operational flexibility that applications requiring an embedded database depend on.

Run-time Performance and Reliability

Embedded InnoDB delivers all the capabilities of the InnoDB storage engine for embedded use:

• high performance and scalability
• multi-version concurrency with row-level locking
• automatic deadlock detection
• fault tolerance and automatic crash recovery
• clustered and secondary B-tree indexes
• automatic insert buffering and hash indexing
• schema management
• table compression

Programmatic Capability

Embedded InnoDB provides applications written in C/C++ a non-SQL, ISAM-like set of functional interfaces for creating tables and indexes, performing queries, inserts, updates, deletes and executing other data management functions. Embeded InnoDB offers the following features for application programmers:

• ISAM-like, non-SQL API
• cursor management
• transaction management
• queries against primary (clustered) and secondary indexes
• strong data types

Operational Flexibility

Embedded InnoDB is designed for use in environment that require automatic operations without a database administrator. Embedded InnoDB has these important operational characteristics for stand-along applications and devices:

• small footprint (838KB)
• automatic configuration
• API calls to set configuration parameters
• fully-multi-threaded
• restartable without process reload