1084:
625:
282:
1027:
180:
66:
25:
511:
Aria was initially named "Maria", as a reference to Monty's youngest child. It was renamed Aria in 2010 to avoid confusion with the main database it is developed for, MariaDB. Chris Tooley, who won a contest to suggest the name, wrote, "Aria is Maria without the 'M'; also it is a pleasant
576:
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.
76:
610:
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.
1068:
1174:
1125:
1164:
745:
1159:
38:
90:
of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be
691:
482:
1061:
630:
784:
317:
263:
161:
52:
201:
194:
675:
244:
142:
1169:
1118:
216:
114:
87:
1054:
816:
223:
121:
1091:
83:
99:
1111:
986:
384:
362:
230:
128:
1034:
437:
44:
190:
1144:
994:
1083:
212:
110:
1004:
716:
613:
In order to set the table format, one can use the ROW_FORMAT option in a CREATE TABLE or ALTER TABLE command.
920:
638:
741:
774:
504:, a community-developed branch of the MySQL database led by Widenius. Aria is not shipped with MySQL or
95:
351:
490:
91:
809:
420:
695:
894:
410:
237:
135:
607:
PAGE is the only format available for "transactional" tables. It makes Aria tables crash-safe.
1095:
1038:
524:
Aria is very similar to MyISAM, but its purpose is to be a crash-safe alternative to MyISAM.
1154:
1026:
848:
778:
497:
432:
935:
869:
679:
425:
295:
Please help update this article to reflect recent events or newly available information.
1149:
802:
672:
550:
505:
471:
1138:
940:
853:
788:
448:
1009:
528:
179:
16:
Storage engine for the MariaDB and MySQL relational database management systems
879:
620:
346:
336:
884:
538:
999:
975:
971:
955:
899:
889:
829:
544:
501:
475:
950:
930:
925:
915:
874:
653:
648:
643:
486:
794:
720:
496:
Aria has been in development since 2007 and was first announced by
403:
843:
825:
769:
479:
82:
Please help to demonstrate the notability of the topic by citing
513:
798:
275:
173:
59:
18:
562:
Non-partitioned Aria tables consist of three physical files:
500:
on his blog. Aria is used for internal temporary tables in
1099:
1042:
985:
964:
908:
862:
836:
584:Three table formats are available for Aria tables:
443:
431:
419:
409:
399:
383:
361:
345:
335:
485:. Its goal is to make a crash-safe alternative to
77:notability guidelines for products and services
1119:
1062:
810:
8:
330:
53:Learn how and when to remove these messages
1126:
1112:
1069:
1055:
817:
803:
795:
329:
318:Learn how and when to remove this message
264:Learn how and when to remove this message
162:Learn how and when to remove this message
665:
368:MariaDB 10.0.12 / June 16, 2014
483:relational database management systems
200:Please improve this article by adding
7:
1080:
1078:
1023:
1021:
631:Free and open-source software portal
1175:Free and open-source software stubs
785:Maria: The new MySQL Storage Engine
692:"Aria FAQ - AskMonty KnowledgeBase"
1098:. You can help Knowledge (XXG) by
1041:. You can help Knowledge (XXG) by
791:- A talk given by Michael Widenius
14:
770:Aria in the MariaDB KnowledgeBase
34:This article has multiple issues.
1082:
1025:
623:
280:
178:
64:
23:
1165:Free software programmed in C++
748:from the original on 2010-07-23
75:may not meet Knowledge (XXG)'s
42:or discuss these issues on the
1160:Software using the GPL license
742:"Rename Maria Contest Winner!"
719:. askmonty.org. Archived from
531:and, currently, transactions.
1:
1092:free and open-source software
673:Aria – AskMonty KnowledgeBase
202:secondary or tertiary sources
775:The Maria engine is released
1191:
1077:
1020:
213:"Aria" storage engine
111:"Aria" storage engine
84:reliable secondary sources
73:The topic of this article
395:
357:
289:This article needs to be
498:Michael "Monty" Widenius
1170:Database software stubs
972:MySQL Stored Procedures
1037:-related article is a
527:Aria does not support
370:; 10 years ago
189:relies excessively on
781:(founder of MySQL AB)
678:May 31, 2009, at the
457:/aria-storage-engine
965:Procedural Language
332:
987:Forks and Branches
895:Database Workbench
337:Original author(s)
79:
1107:
1106:
1050:
1049:
1035:database software
1018:
1017:
465:
464:
328:
327:
320:
310:
309:
274:
273:
266:
248:
172:
171:
164:
146:
74:
57:
1182:
1145:Database engines
1128:
1121:
1114:
1086:
1079:
1071:
1064:
1057:
1029:
1022:
849:MySQL Enterprise
819:
812:
805:
796:
779:Michael Widenius
757:
756:
754:
753:
738:
732:
731:
729:
728:
713:
707:
706:
704:
703:
694:. Archived from
688:
682:
670:
633:
628:
627:
626:
461:
458:
456:
454:
452:
450:
378:
376:
371:
352:Monty Program Ab
333:
323:
316:
305:
302:
296:
284:
283:
276:
269:
262:
258:
255:
249:
247:
206:
182:
174:
167:
160:
156:
153:
147:
145:
104:
68:
67:
60:
49:
27:
26:
19:
1190:
1189:
1185:
1184:
1183:
1181:
1180:
1179:
1135:
1134:
1133:
1132:
1076:
1075:
1019:
1014:
981:
960:
936:MySQL Federated
909:Storage engines
904:
870:MySQL Workbench
858:
832:
823:
766:
761:
760:
751:
749:
744:. GNOME Blogs.
740:
739:
735:
726:
724:
715:
714:
710:
701:
699:
690:
689:
685:
680:Wayback Machine
671:
667:
662:
629:
624:
622:
619:
582:
560:
558:Files structure
551:Virtual columns
534:Aria supports:
522:
447:
426:Database engine
391:
385:Preview release
379:
374:
372:
369:
324:
313:
312:
311:
306:
300:
297:
294:
285:
281:
270:
259:
253:
250:
207:
205:
199:
195:primary sources
183:
168:
157:
151:
148:
105:
103:
81:
69:
65:
28:
24:
17:
12:
11:
5:
1188:
1186:
1178:
1177:
1172:
1167:
1162:
1157:
1152:
1147:
1137:
1136:
1131:
1130:
1123:
1116:
1108:
1105:
1104:
1087:
1074:
1073:
1066:
1059:
1051:
1048:
1047:
1030:
1016:
1015:
1013:
1012:
1007:
1002:
997:
991:
989:
983:
982:
980:
979:
974:(a variant of
968:
966:
962:
961:
959:
958:
953:
948:
943:
938:
933:
928:
923:
918:
912:
910:
906:
905:
903:
902:
897:
892:
887:
882:
877:
872:
866:
864:
860:
859:
857:
856:
851:
846:
840:
838:
834:
833:
824:
822:
821:
814:
807:
799:
793:
792:
782:
772:
765:
764:External links
762:
759:
758:
733:
717:"Rename Maria"
708:
683:
664:
663:
661:
658:
657:
656:
651:
646:
641:
635:
634:
618:
615:
605:
604:
598:
592:
581:
578:
574:
573:
572:table_name.MAI
570:
569:table_name.MAD
567:
566:table_name.frm
559:
556:
555:
554:
548:
542:
521:
518:
506:Percona Server
472:storage engine
463:
462:
445:
441:
440:
435:
429:
428:
423:
417:
416:
413:
407:
406:
401:
397:
396:
393:
392:
389:
387:
381:
380:
367:
365:
363:Stable release
359:
358:
355:
354:
349:
343:
342:
339:
326:
325:
308:
307:
288:
286:
279:
272:
271:
186:
184:
177:
170:
169:
72:
70:
63:
58:
32:
31:
29:
22:
15:
13:
10:
9:
6:
4:
3:
2:
1187:
1176:
1173:
1171:
1168:
1166:
1163:
1161:
1158:
1156:
1153:
1151:
1148:
1146:
1143:
1142:
1140:
1129:
1124:
1122:
1117:
1115:
1110:
1109:
1103:
1101:
1097:
1094:article is a
1093:
1088:
1085:
1081:
1072:
1067:
1065:
1060:
1058:
1053:
1052:
1046:
1044:
1040:
1036:
1031:
1028:
1024:
1011:
1008:
1006:
1003:
1001:
998:
996:
993:
992:
990:
988:
984:
977:
973:
970:
969:
967:
963:
957:
954:
952:
949:
947:
944:
942:
941:MySQL Archive
939:
937:
934:
932:
929:
927:
924:
922:
919:
917:
914:
913:
911:
907:
901:
898:
896:
893:
891:
888:
886:
883:
881:
878:
876:
873:
871:
868:
867:
865:
863:SQL GUI tools
861:
855:
854:MySQL Cluster
852:
850:
847:
845:
842:
841:
839:
835:
831:
827:
820:
815:
813:
808:
806:
801:
800:
797:
790:
789:Google Videos
786:
783:
780:
777:- written by
776:
773:
771:
768:
767:
763:
747:
743:
737:
734:
723:on 2010-05-03
722:
718:
712:
709:
698:on 2010-08-22
697:
693:
687:
684:
681:
677:
674:
669:
666:
659:
655:
652:
650:
647:
645:
642:
640:
637:
636:
632:
621:
616:
614:
611:
608:
602:
599:
596:
593:
590:
587:
586:
585:
579:
577:
571:
568:
565:
564:
563:
557:
552:
549:
546:
543:
540:
537:
536:
535:
532:
530:
525:
519:
517:
515:
509:
507:
503:
499:
494:
492:
491:transactional
488:
484:
481:
477:
473:
469:
460:
446:
442:
439:
436:
434:
430:
427:
424:
422:
418:
414:
412:
408:
405:
402:
398:
394:
388:
386:
382:
366:
364:
360:
356:
353:
350:
348:
344:
340:
338:
334:
322:
319:
304:
292:
287:
278:
277:
268:
265:
257:
246:
243:
239:
236:
232:
229:
225:
222:
218:
215: –
214:
210:
209:Find sources:
203:
197:
196:
192:
187:This article
185:
181:
176:
175:
166:
163:
155:
144:
141:
137:
134:
130:
127:
123:
120:
116:
113: –
112:
108:
107:Find sources:
101:
97:
93:
89:
85:
78:
71:
62:
61:
56:
54:
47:
46:
41:
40:
35:
30:
21:
20:
1100:expanding it
1089:
1043:expanding it
1032:
945:
750:. Retrieved
736:
725:. Retrieved
721:the original
711:
700:. Retrieved
696:the original
686:
668:
612:
609:
606:
600:
594:
588:
583:
575:
561:
533:
529:foreign keys
526:
523:
514:musical term
510:
495:
489:. It is not
467:
466:
347:Developer(s)
341:AskMonty.org
314:
298:
290:
260:
251:
241:
234:
227:
220:
208:
188:
158:
149:
139:
132:
125:
118:
106:
50:
43:
37:
36:Please help
33:
1010:WebScaleSQL
547:data types;
254:August 2011
152:August 2011
88:independent
1139:Categories
880:phpMyAdmin
752:2018-01-21
727:2011-05-19
702:2010-11-10
660:References
400:Written in
375:2014-06-16
224:newspapers
191:references
122:newspapers
96:redirected
39:improve it
978:Standard)
438:GNU GPLv2
301:July 2014
86:that are
45:talk page
885:HeidiSQL
837:Editions
746:Archived
676:Archived
617:See also
541:indexes;
539:Fulltext
520:Features
474:for the
411:Platform
1155:MariaDB
1005:Percona
1000:MariaDB
995:Drizzle
976:SQL/PSM
956:MyRocks
900:DBeaver
890:Navicat
830:MariaDB
601:DYNAMIC
580:Formats
545:OpenGIS
502:MariaDB
476:MariaDB
449:mariadb
444:Website
433:License
390:All
373: (
291:updated
238:scholar
136:scholar
100:deleted
951:TokuDB
931:XtraDB
926:InnoDB
921:Falcon
916:MyISAM
875:SQLyog
654:XtraDB
649:MyISAM
644:InnoDB
639:Falcon
487:MyISAM
240:
233:
226:
219:
211:
138:
131:
124:
117:
109:
92:merged
1150:MySQL
1090:This
1033:This
844:MySQL
826:MySQL
595:FIXED
480:MySQL
470:is a
245:JSTOR
231:books
143:JSTOR
129:books
98:, or
1096:stub
1039:stub
946:Aria
828:and
589:PAGE
478:and
468:Aria
451:.com
421:Type
331:Aria
217:news
115:news
787:at
516:."
455:/en
453:/kb
415:All
404:C++
193:to
1141::
508:.
493:.
204:.
94:,
48:.
1127:e
1120:t
1113:v
1102:.
1070:e
1063:t
1056:v
1045:.
818:e
811:t
804:v
755:.
730:.
705:.
603:.
597:;
591:;
553:.
459:/
377:)
321:)
315:(
303:)
299:(
293:.
267:)
261:(
256:)
252:(
242:·
235:·
228:·
221:·
198:.
165:)
159:(
154:)
150:(
140:·
133:·
126:·
119:·
102:.
80:.
55:)
51:(
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.