Monday, February 23, 2009
Maria - MySQL Storage Engine
Keywords: Maria Storage Engine, Maria, Storage Engine, MySQL Storage Engine, MyISAM Replacement Engine, MyISAM, Auto Recovery type MariaIn nutshell, Maria Storage Engine is a crash safe version of MyISAM.
Maria Engine is an extended version of the MyISAM Engine, which is crash safe and provides more concurrency. The Maria storage engine supports all of the main functionality of the MyISAM engine, but includes recovery support (in the event of a system crash), full logging (including CREATE, DROP, RENAME and TRUNCATE operations), all MyISAM row formats and a new Maria specific row format.
It aims to be fully transactional (ACID) soon.
Maria will be a replacement mysql storage engine for the existing MyISAM Engine.
A Maria type table shall be created as like other type of tables using ENGINE option in the "create table" statement.
MySQL> create table tablename (fieldname fieldtype) engine=maria;
Alternatively an existing table shall be converted into maria type table as specified in the following statement:
MySQL> alter table tablename engine=maria;
Maria type table will create three files like myisam with different extensions as following:
- tablename.frm
- tablename.mad
- tablename.mai
Maria File Types & Explanation
- *.frm - table definition and structure
- *.mad - data file of the maria type table
- *.mai - index file of the maria type table
Maria Storage Engine Features
- Maria supports auto-recovery in the event of a crash
- Maria supports a single writer and multiple readers
- Maria provides a new row format, PAGE
- Maria supports crash-safe operations over many statements by enclosing statements within LOCK TABLES and UNLOCK TABLES statements
Keywords: Maria Storage Engine, Maria, Storage Engine, MySQL Storage Engine, MyISAM Replacement Engine, MyISAM, Auto Recovery type Maria
- MySQL LEFT JOIN - http://kathyravan.blogspot.com/2009/01/mysql-left-join.html
- MySQL SQL_CACHE - http://kathyravan.blogspot.com/2008/12/mysql-sqlcache.html
- MySQL Query Caching - http://kathyravan.blogspot.com/2008/12/mysql-query-cache.html
- MySQL Show - http://kathyravan.blogspot.com/2008/12/mysql-show-statements.html
- CSV - MySQL Storage Engine - http://kathyravan.blogspot.com/2008/12/csv-mysql-storage-engine.html
- Blackhole - MySQL Storage Engine - http://kathyravan.blogspot.com/2008/12/blackhole-mysql-storage-engine.html
- Memory - MySQL Storage Engine (Formerly Heap Storage Engine) - http://kathyravan.blogspot.com/2008/12/memory-mysql-storage-engine-formerly.html
- Xml in MySQL - http://kathyravan.blogspot.com/2008/03/xml-in-mysql.html
- Forgot mySQL root Password? - http://kathyravan.blogspot.com/2008/02/forgot-mysql-root-password.html
- Samba - Installation & Configuration - http://kathyravan.blogspot.com/2008/02/samba-installation-configuration.html
- Enabling HTTP Authentication in Apache - http://kathyravan.blogspot.com/2008/08/enabling-http-authentication-in-apache.html
- PHP Function: isFTPFileExists (Searching a FILE in FTP) - http://kathyravan.blogspot.com/2008/12/php-function-isftpfileexists-searching.html
- Shell Scripting & Linux - http://kathyravan.blogspot.com/search/label/Shell%20Scripts
No comments :
Post a Comment