请输入您要查询的百科知识:

 

词条 Aria (storage engine)
释义

  1. Features

  2. Files structure

     Formats 

  3. See also

  4. References

  5. External links

{{multiple issues|{{Notability|Products|date=August 2011}}{{primary sources|date=August 2011}}{{update|date=July 2014}}
}}{{Infobox software
| name = Aria
| logo =
| screenshot =
| caption =
| author = AskMonty.org
| developer = Monty Program Ab
| released =
| latest release version = MariaDB 10.0.12
| latest release date = {{start date and age|2014|06|16}}
| latest preview version = All
| latest preview date =
| operating system =
| platform = All
| language = C++
| genre = Database engine
| license = GNU GPLv2
| website = {{URL|http://kb.askmonty.org/v/aria}}
}}

Aria is a storage engine for the MariaDB and MySQL relational database management systems. Its goal is to make a crash-safe alternative to MyISAM. It is not yet transactional but plans to add proper support for database transactions at some point in the future. The long-term goal is for Aria to be the default transactional and non-transactional storage engine for MariaDB. It has been in development since 2007 and was first announced by Michael "Monty" Widenius on his blog.[1] Aria is used for internal temporary tables in MariaDB, a community-developed branch of the MySQL database led by Widenius. Aria is not shipped with MySQL or Percona Server, but is included in the TokuDB release of MariaDB.

The Maria project is hosted on Launchpad.

Aria was initially named "Maria", as a reference to Monty's youngest child.[2]

It was renamed Aria in 2010 to avoid confusion with the main database it is developed for, MariaDB.[3]

Aria is Maria without the "M"; also it is a pleasant musical term.[4]

Features

Aria is very similar to MyISAM, but its purpose is to be a crash-safe alternative to MyISAM.

Aria does not support foreign keys and, currently, transactions.

Aria supports:

  • Fulltext indexes;
  • OpenGIS data types;
  • Virtual columns.

Files structure

Non-partitioned Aria tables consist of three physical files:

  • table_name.frm
  • table_name.MAD
  • table_name.MAI

The .frm file contains the table definition (this file exists for all storage engines which write data to disk). The .MAD file contains the data. The .MAI file contains the indexes.

Formats

Three table formats are available for Aria tables:

  • PAGE;
  • FIXED;
  • DYNAMIC.

PAGE is the only format available for transactional tables.

FIXED and DYNAMIC are the same formats used by MyISAM, and have been mainly implemented for compatibility. However, MyISAM's COMPRESSED format is not available in Aria.

In order to set the table format, one can use the ROW_FORMAT option in a CREATE TABLE or ALTER TABLE command.

See also

{{Portal|Free and open-source software}}
  • Falcon
  • InnoDB
  • MyISAM
  • XtraDB

References

1. ^Aria - AskMonty KnowledgeBase {{webarchive |url=https://web.archive.org/web/20090531154308/http://askmonty.org/wiki/index.php/Maria#What_is_Maria.3F |date=May 31, 2009 }}
2. ^Aria FAQ - AskMonty KnowledgeBase
3. ^{{cite web|title=Rename Maria |url=http://askmonty.org/wiki/Rename_Maria |archive-url=https://web.archive.org/web/20100503155953/http://askmonty.org/wiki/Rename_Maria |dead-url=yes |archive-date=2010-05-03 |publisher=askmonty.org |accessdate=2011-05-19 }}
4. ^{{cite web|title=Rename Maria Contest Winner! |url=https://blogs.gnome.org/mneptok/2010/07/20/rename-maria-contest-winner/|dead-url=no |publisher=GNOME Blogs |accessdate=2018-01-21 }}

External links

  • {{Official website}}
  • The Maria engine is released - written by Michael Widenius (founder of MySQL AB)
  • [https://web.archive.org/web/20110714170246/http://video.google.com/videoplay?docid=-9141778279227463045 Maria: The new MySQL Storage Engine] at Google Videos - A talk given by Michael Widenius
{{MySQL}}{{DEFAULTSORT:Aria (Storage Engine)}}{{database-software-stub}}{{Free-software-stub}}

2 : Database engines|MySQL

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/12 1:21:43