MySQL Archive

ArchiveStorage Engine
Original author(s)Brian Aker
Initial release2004
Written inC, C++
Operating systemCross-platform
Platformx86, x86-64, SPARC, MIPS, PowerPC
TypeDatabase engine
LicenseGNU General Public License
Websitemysql.bkbits.com Edit this on Wikidata

Archive is a storage engine for the MySQL relational database management system. Users can use this analytic storage engine to create a table that is “archive” only. Data cannot be deleted from this table, only added. The Archive engine uses a compression strategy based on the zlib library and it packs the rows using a bit header to represent nulls and removes all whitespace for character type fields. When completed, the row is inserted into the compression buffer and flushed to disk by an explicit flush table, a read, or the closing of the table.

One of the current restrictions of Archive tables is that they do not support any indexes, thus necessitating a table scan for any SELECT tasks. Archive tables, however, are supported by the MySQL Query Cache, which can dramatically reduce response times for Archive table queries that are repetitively issued.[1] MySQL is examining index support for Archive tables in upcoming releases.

The engine is not ACID compliant. Unlike OLTP engines, it uses a "stream" format to disk with no block boundaries. The head of the Archive file generated is a byte array representing the data format and contents of that file. In MySQL 5.1, a copy of the MySQL FRM file is stored in the header of each Archive file. The FRM file, which represents the definition of a table, allows an Archive file to be restored to a MySQL server if the Archive file is copied to the server.

Despite the use of zlib, archive files are not compatible with gzio, the basis of the gzip tools. It uses its own azio system that is a fork of gzio.

Archive differs from the other MySQL analytical engine, MyISAM, by being a row-level locking engine and by keeping a constant version snapshot throughout a single query (making it MVCC). This means that Archive does not lock for concurrent bulk inserts. For bulk inserts it performs an interlaced INSERT, so unlike MyISAM, order is not guaranteed.

Users can use the archive_reader tool to take an online snapshot of a table and to change the characteristics of an archive file.

To create an Archive table, specify the following engine string: 

create table t1 (
 a int,
 b varchar(32))
ENGINE=ARCHIVE

The MySQL [2] Archive Storage Engine was authored and is maintained by Brian Aker. It was introduced in 2004 with MySQL 4.1.

References

  1. ^ https://web.archive.org/web/20100212100829/http://dev.mysql.com/tech-resources/articles/storage-engine.html The MySQL 5.0 Archive Storage Engine (archive date 20100212)
  2. ^ MySQL Tutorial


Stub icon

This database software-related article is a stub. You can help Wikipedia by expanding it.

Read other articles:

.gm

Domain .GM .gm adalah top-level domain kode negara Internet untuk Gambia. lbsRanah tingkat teratas kode negara (ccTLD)ISO 3166-1 A .ac .ad .ae .af .ag .ai .al .am .ao .aq .ar .as .at .au .aw .ax .az   B .ba .bb .bd .be .bf .bg .bh .bi .bj .bm .bn .bo .br .bs .bt .bw .by .bz   C .ca .cc .cd .cf .cg .ch .ci .ck .cl .cm .cn .co .cr .cu .cv .cw .cx .cy .cz   D .de .dj .dk .dm .do .dz   E .ec .ee .eg .er .es .et .eu   F...

 

Keuskupan Agung Eger

Keuskupan Agung EgerArchidioecesis AgriensisEgri főegyházmegyeBasilika Katedral EgarLokasiNegara HungariaProvinsi gerejawiEgerStatistikLuas11.500 km2 (4.400 sq mi)Populasi- Total- Katolik(per 2013)1.260.000685,000 (54.4%)InformasiRitusRitus LatinKatedralBasilika Katedral Santo Yohanes Penginjil, Santo Mikael dan Dikandung Tanpa Noda di EgerKepemimpinan kiniPausFransiskusUskup AgungCsaba TernyákAuksilierFerenc PalankiEmeritusIstván Katona Uskup Auksi...

 

Sevenoaks Gravel Pits

Sevenoaks Gravel PitsSite of Special Scientific InterestLocationKentGrid referenceTQ 522 569[1]InterestBiologicalArea73.7 hectares (182 acres)[1]Notification1989[1]Location mapMagic Map Sevenoaks Gravel Pits is a 73.7-hectare (182-acre) biological Site of Special Scientific Interest on the northern outskirts of Sevenoaks in Kent.[1][2] It is managed by Kent Wildlife Trust as the Sevenoaks Wildlife Reserve and Jeffery Harrison Visitor Centre.[3]...

ويكيبيديا:بوت

البوت هو برنامج حاسوب مكتوب بلغة برمجة معينة؛ كتبه أشخاص لكي يقوم بإنجاز أعمال كثيرة وبسيطة ومملة ومتكررة بالنيابة عنهم. مثل تلك الأعمال الخاصة بإضافة قوالب الصيانة والتصانيف على مقالات ويكيبيديا. يستعمل البوت بكثرة على مختلف صفحات ويكيبيديا بمختلف اللغات. كل بوت له صفحة...

 

1929 All-Ireland Senior Football Championship final

Football match1929 All-Ireland Senior Football FinalKerry, championsEvent1929 All-Ireland Senior Football Championship Kerry Kildare 1-8(11) 1-5(8) Date22 September 1929VenueCroke Park, DublinRefereeTom Burke (Louth)Attendance43,839← 1928 1930 → The 1929 All-Ireland Senior Football Championship Final was the 42nd All-Ireland Final and the deciding match of the 1929 All-Ireland Senior Football Championship, an inter-county Gaelic football tournament for the top teams in Ireland. K...

 

Skara

Place in Västergötland, Sweden For the fossil crustacean, see Skara (crustacean). This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Skara – news · newspapers · books · scholar · JSTOR (October 2010) (Learn how and when to remove this template message) Place in Västergötland, SwedenSkaraSkara Cathedral Coat...

Nacional FBC

Peruvian football club Football clubNacionalFull nameNacional FBCNickname(s) RojiblancosFoundedApril 18, 1923GroundEstadio Municipal de Mollendo,MollendoLeagueCopa Perú Home colours Nacional FBC (sometimes referred as Nacional) is a Peruvian football club, playing in the city of Mollendo, Islay, Arequipa, Peru. History The Club Deportivo Mariscal Miller was founded on April 18, 1923.[1] Despite being a historic club, they have only won the 1946, 2019 and 2022 Liga Distrital de Mollen...

 

Distretto di Neubrandenburg

Distretto di NeubrandenburgInformazioni generaliNome ufficialeBezirk Neubrandenburg CapoluogoNeubrandenburg 620.500 abitanti (1989) Dipendente da Germania Est Suddiviso in1 città extracircondariale15 circondari Evoluzione storicaInizio25 luglio 1952 CausaSuddivisione della RDT in distretti Fine3 ottobre 1990 CausaRiunificazione tedesca Preceduto da Succeduto da Meclemburgo Meclemburgo-Pomerania Anteriore Cartografia Il distretto di Neubrandenburg (Bezirk Neubrandenburg) era uno dei 14 d...

 

Candy Crush Saga

Candy Crush Saga PublikasiFacebook:12 April 2012iPhone/iPad:14 November 2012Android:14 Desember 2012GenrePuzzleModel bisnisFree-to-play Karakteristik teknisSistem operasiAndroid dan iOS PlatformAndroid, Windows Phone, iOS, Windows dan Windows 10 Mobile MesinAdobe Flash ModePermainan video pemain tunggal Formatdistribusi digital dan unduhan digital Metode inputlayar sentuh Format kode Daftar 30 Informasi pengembangPengembangKingPenerbitActivision Blizzard, Bursa Microsoft, Google Play dan App ...

Jiwasraya

Gaya atau nada penulisan artikel ini tidak mengikuti gaya dan nada penulisan ensiklopedis yang diberlakukan di Wikipedia. Bantulah memperbaikinya berdasarkan panduan penulisan artikel. (Pelajari cara dan kapan saatnya untuk menghapus pesan templat ini) Artikel ini perlu diwikifikasi agar memenuhi standar kualitas Wikipedia. Anda dapat memberikan bantuan berupa penambahan pranala dalam, atau dengan merapikan tata letak dari artikel ini. Untuk keterangan lebih lanjut, klik [tampil] di bagian ka...

 

Copacabana Fort revolt

1922 Brazilian revolt Copacabana Fort revoltPart of TenentismThe last rebels in their march to deathFrom left to righ: Eduardo Gomes, Siqueira Campos, Newton Prado and Otávio Correia, a civilianDate4–6 July 1922 (Rio de Janeiro) 5–13 July (Mato Grosso)LocationRio de Janeiro, Niterói and Mato GrossoResult Government victoryBelligerents Army and civilian rebels Brazil Brazilian Army Brazilian Navy Federal District Police São Paulo Police[a]Commanders and leaders Hermes da Fonseca...

 

Widelux

Swing-lens panoramic camera Panon redirects here. For the town in France, see Panon, Sarthe. This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Widelux – news · newspapers · books · scholar · JSTOR (May 2009) (Learn how and when to remove this message) Widelux F7Widelux model F7OverviewMakerPanon Camera ShokoTy...

جيرزي

  جيرزي (بالإنجليزية: Jersey)‏  جيرزيعلم جيرزي  جيرزيالشعار   النشيد: ليحفظ الله الملك  الأرض والسكان إحداثيات 49°11′N 2°07′W / 49.19°N 2.11°W / 49.19; -2.11   [1] المساحة 118.2 كيلومتر مربع  عاصمة ساينت هيلير  اللغة الرسمية الإنجليزية،  وجيرزية  التعداد...

 

Renewable energy in Austria

Installed grid interactive renewable power capacity in Austria as of 24 November 2021 [1]   Wind Power: 3,500 MW (19.0%)   Solar Power: 2,500 MW (13.6%)   Biomass Power: 482 MW (2.6%)   Hydro Power: 11,812 MW (64.2%)   Energy from Waste: 103 MW (0.6%) Installed grid power capacity from all sources in Austria as of 24 November 2021[1]   Coal: 0 MW (0.0%)   Other Renewables: 6,482 MW (28.3%)   Hydro Power: 11,815 MW (51.6%)   Gas: 4,...

 

Rubella

Human viral disease This article is about the disease. For other uses, see Rubella (disambiguation). Not to be confused with either rubeola or roseola, which are also viral diseases with comparable features. Medical conditionRubellaOther namesGerman measles, three-day measlesA rash due to rubella on a child's back. The area affected is similar to that of measles but the rash is less intensely red.SpecialtyInfectious diseaseSymptomsRash, swollen lymph nodes, fever, sore throat, feeling tired&#...

D. P. Mohapatra

D. P. Mohapatra Hakim Mahkamah Agung IndiaMasa jabatan09-12-1998–02-08-2002 Informasi pribadiKebangsaanIndiaProfesiHakimSunting kotak info • L • B D. P. Mohapatra adalah hakim Mahkamah Agung India. Ia mulai menjabat sebagai hakim di mahkamah tersebut pada 09-12-1998. Masa baktinya sebagai hakim berakhir pada 02-08-2002.[1] Referensi ^ Daftar Hakim di Mahkamah Agung India. Mahkamah Agung India. Diakses tanggal 10 Juni 2021.  Artikel bertopik biografi India ini adal...

 

Francesco Soave

Francesco Soave (Lugano, 10 giugno 1743 – Pavia, 17 gennaio 1806) è stato un filosofo, traduttore e docente svizzero-italiano. Per qualche tempo maestro di Alessandro Manzoni, fu il più efficace divulgatore del sensismo italiano[1]. Lapide commemorativa di Soave all'Università di Pavia. Indice 1 Biografia 2 Opere 3 Note 4 Bibliografia 5 Voci correlate 6 Altri progetti 7 Collegamenti esterni Biografia Nacque a Lugano da Giuseppe Soave e Clara Herrik. La sua numerosa famiglia versa...

 

A.J.C. de Neve

Adriaan Johan Charles de Neve Adriaan Johan Charles de Neve (Padang, Hindia Belanda (kini Indonesia), 1857 - Den Haag, Belanda, 15 Januari 1913) adalah asisten residen Belanda di Aceh, residen di Divisi Barat Kalimantan dan Ksatria Militaire Willems-Orde. Karier Atas perannya sebagai asisten residen di Aceh, De Neve diangkat sebagai kesatria Militaire Willems-Orde berdasarkan Surat Keputusan no. 19 tgl. 19 Maret 1897. Kemudian, ia menjadi residen di Divisi Barat Kalimantan. Pada tahun 1892, i...

كلويشيفسكايا سوبكا

كلويشيفسكايا سوبكا   الموقع روسيا  المنطقة كراي كامشاتكا  إحداثيات 56°04′00″N 160°38′00″E / 56.066666666667°N 160.63333333333°E / 56.066666666667; 160.63333333333   الارتفاع 4800 متر  النتوء 4649 متر  تعديل مصدري - تعديل   بركان كليوشيفسكايا سوبكا كليوشيفسكايا سوبكا (الروسية: Ключев...

 

WCCT-TV

CW affiliate in Waterbury, Connecticut This article is about the Connecticut television station. For the South Carolina television station which previously held this call sign, see WACH. WTXX-TV redirects here. Not to be confused with WTXX-LD. WCCT-TVATSC 3.0 stationWaterbury–Hartford–New Haven, ConnecticutUnited StatesCityWaterbury, ConnecticutChannelsDigital: 33 (UHF)Virtual: 20BrandingCW 20ProgrammingAffiliations20.1: The CWfor others, see § SubchannelsOwnershipOwnerTegna Inc.(Te...