csv storage engine

 

what types of storage engines are available:

Inno DB
CSV
Merge
Blackhole
Federated
eBay Memory Engine
Maria
PBXT
MySQL storage engines
NitroEDB
XtraDB
eBay Memory Engine
Solid

CSV
The CSV (Comma Separated Value ) storage engine allows the management of an underlying CSV file via SQL statements. In MySQL 5.1, the general query log and the slow query log are actually implemented as the CSV engine.

Key features of csv:

 

Interchangeable data with other programs
Fast import time via fisle copy
Key Features of CSV :
Plain text data format

Limitations of CSV :

Non-transactional
Does not support indexes
Table level locking

Understanding CSV Table Usage:

How csv stores data in table:

An CSV table is represented as three separate files in the file system located in the defi ned data directory for the MySQL instance.
table.CSV: This is the table data file
table.CSM: This is the CSV table meta data
table.frm: This is the table format definition file.