Matches in DBpedia 2016-04 for { <http://dbpedia.org/resource/MySQL_Archive> ?p ?o }
Showing triples 1 to 82 of
82
with 100 triples per page.
- MySQL_Archive 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.".
- MySQL_Archive author Brian_Aker.
- MySQL_Archive computingPlatform MIPS_instruction_set.
- MySQL_Archive computingPlatform PowerPC.
- MySQL_Archive computingPlatform SPARC.
- MySQL_Archive computingPlatform X86.
- MySQL_Archive computingPlatform X86-64.
- MySQL_Archive genre Database_engine.
- MySQL_Archive license GNU_General_Public_License.
- MySQL_Archive operatingSystem Cross-platform.
- MySQL_Archive programmingLanguage C++.
- MySQL_Archive programmingLanguage C_(programming_language).
- MySQL_Archive status "Active".
- MySQL_Archive wikiPageExternalLink archive-storage-engine.html.
- MySQL_Archive wikiPageExternalLink mysql.bkbits.com.
- MySQL_Archive wikiPageID "13116285".
- MySQL_Archive wikiPageLength "3698".
- MySQL_Archive wikiPageOutDegree "24".
- MySQL_Archive wikiPageRevisionID "596219574".
- MySQL_Archive wikiPageWikiLink ACID.
- MySQL_Archive wikiPageWikiLink Brian_Aker.
- MySQL_Archive wikiPageWikiLink C++.
- MySQL_Archive wikiPageWikiLink C_(programming_language).
- MySQL_Archive wikiPageWikiLink Category:Database_engines.
- MySQL_Archive wikiPageWikiLink Category:MySQL.
- MySQL_Archive wikiPageWikiLink Cross-platform.
- MySQL_Archive wikiPageWikiLink Database_engine.
- MySQL_Archive wikiPageWikiLink GNU_General_Public_License.
- MySQL_Archive wikiPageWikiLink Gzio.
- MySQL_Archive wikiPageWikiLink Gzip.
- MySQL_Archive wikiPageWikiLink MIPS_instruction_set.
- MySQL_Archive wikiPageWikiLink Multiversion_concurrency_control.
- MySQL_Archive wikiPageWikiLink MyISAM.
- MySQL_Archive wikiPageWikiLink MySQL.
- MySQL_Archive wikiPageWikiLink Online_transaction_processing.
- MySQL_Archive wikiPageWikiLink PowerPC.
- MySQL_Archive wikiPageWikiLink Relational_database_management_system.
- MySQL_Archive wikiPageWikiLink SPARC.
- MySQL_Archive wikiPageWikiLink X86.
- MySQL_Archive wikiPageWikiLink X86-64.
- MySQL_Archive wikiPageWikiLink Zlib.
- MySQL_Archive wikiPageWikiLinkText "Archive".
- MySQL_Archive wikiPageWikiLinkText "MySQL Archive Storage Engine".
- MySQL_Archive wikiPageWikiLinkText "MySQL Archive".
- MySQL_Archive author Brian_Aker.
- MySQL_Archive collapsible "yes".
- MySQL_Archive genre Database_engine.
- MySQL_Archive license GNU_General_Public_License.
- MySQL_Archive name "ArchiveStorage Engine".
- MySQL_Archive operatingSystem Cross-platform.
- MySQL_Archive platform MIPS_instruction_set.
- MySQL_Archive platform PowerPC.
- MySQL_Archive platform SPARC.
- MySQL_Archive platform X86.
- MySQL_Archive platform X86-64.
- MySQL_Archive programmingLanguage C++.
- MySQL_Archive programmingLanguage C_(programming_language).
- MySQL_Archive released "2004".
- MySQL_Archive status "Active".
- MySQL_Archive website mysql.bkbits.com.
- MySQL_Archive wikiPageUsesTemplate Template:Database-software-stub.
- MySQL_Archive wikiPageUsesTemplate Template:Infobox_Software.
- MySQL_Archive wikiPageUsesTemplate Template:MySQL.
- MySQL_Archive wikiPageUsesTemplate Template:Reflist.
- MySQL_Archive subject Category:Database_engines.
- MySQL_Archive subject Category:MySQL.
- MySQL_Archive hypernym Engine.
- MySQL_Archive type Software.
- MySQL_Archive type Work.
- MySQL_Archive type CreativeWork.
- MySQL_Archive type Thing.
- MySQL_Archive type Q386724.
- MySQL_Archive type Q7397.
- MySQL_Archive 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.".
- MySQL_Archive label "MySQL Archive".
- MySQL_Archive sameAs Q6944864.
- MySQL_Archive sameAs m.02z74_t.
- MySQL_Archive sameAs Q6944864.
- MySQL_Archive wasDerivedFrom MySQL_Archive?oldid=596219574.
- MySQL_Archive homepage mysql.bkbits.com.
- MySQL_Archive isPrimaryTopicOf MySQL_Archive.
- MySQL_Archive name "ArchiveStorage Engine".