Matches in DBpedia 2016-04 for { <http://wikidata.dbpedia.org/resource/Q6944864> ?p ?o }
Showing triples 1 to 62 of
62
with 100 triples per page.
- Q6944864 subject Q7484965.
- Q6944864 subject Q8363902.
- Q6944864 abstract "MySQL 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. 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:The MySQL Archive Storage Engine was authored and is maintained by Brian Aker. It was introduced in 2004 with MySQL 4.1.".
- Q6944864 author Q4962934.
- Q6944864 computingPlatform Q182933.
- Q6944864 computingPlatform Q209860.
- Q6944864 computingPlatform Q272629.
- Q6944864 computingPlatform Q273190.
- Q6944864 computingPlatform Q527464.
- Q6944864 genre Q537993.
- Q6944864 license Q7603.
- Q6944864 operatingSystem Q174666.
- Q6944864 programmingLanguage Q15777.
- Q6944864 programmingLanguage Q2407.
- Q6944864 status "Active".
- Q6944864 wikiPageExternalLink archive-storage-engine.html.
- Q6944864 wikiPageExternalLink mysql.bkbits.com.
- Q6944864 wikiPageWikiLink Q1501395.
- Q6944864 wikiPageWikiLink Q15777.
- Q6944864 wikiPageWikiLink Q174666.
- Q6944864 wikiPageWikiLink Q182933.
- Q6944864 wikiPageWikiLink Q207240.
- Q6944864 wikiPageWikiLink Q209860.
- Q6944864 wikiPageWikiLink Q2407.
- Q6944864 wikiPageWikiLink Q272629.
- Q6944864 wikiPageWikiLink Q273190.
- Q6944864 wikiPageWikiLink Q283647.
- Q6944864 wikiPageWikiLink Q288435.
- Q6944864 wikiPageWikiLink Q3932296.
- Q6944864 wikiPageWikiLink Q4962934.
- Q6944864 wikiPageWikiLink Q527464.
- Q6944864 wikiPageWikiLink Q537993.
- Q6944864 wikiPageWikiLink Q7484965.
- Q6944864 wikiPageWikiLink Q7603.
- Q6944864 wikiPageWikiLink Q8363902.
- Q6944864 wikiPageWikiLink Q850.
- Q6944864 wikiPageWikiLink Q917941.
- Q6944864 wikiPageWikiLink Q93695.
- Q6944864 author Q4962934.
- Q6944864 genre Q537993.
- Q6944864 license Q7603.
- Q6944864 name "ArchiveStorage Engine".
- Q6944864 operatingSystem Q174666.
- Q6944864 platform Q182933.
- Q6944864 platform Q209860.
- Q6944864 platform Q272629.
- Q6944864 platform Q273190.
- Q6944864 platform Q527464.
- Q6944864 programmingLanguage Q15777.
- Q6944864 programmingLanguage Q2407.
- Q6944864 status "Active".
- Q6944864 website mysql.bkbits.com.
- Q6944864 type CreativeWork.
- Q6944864 type Software.
- Q6944864 type Work.
- Q6944864 type Thing.
- Q6944864 type Q386724.
- Q6944864 type Q7397.
- Q6944864 comment "MySQL 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.".
- Q6944864 label "MySQL Archive".
- Q6944864 homepage mysql.bkbits.com.
- Q6944864 name "ArchiveStorage Engine".