MySQL Archive: Difference between revisions

Revision as of 08:31, 16 February 2009

Revision as of 14:39, 19 April 2009

Line 1:

{{ Infobox Software

| name = ArchiveStorage Engine

| logo =

| screenshot =

| caption =

| author = [[Brian Aker]]

| collapsible = yes

| developer =

| released = 2004

| status = Active

| latest release version =

| latest release date =

| latest preview version =

| latest preview date =

| operating system = [[Linux]], [[Mac OS X]], [[Unix]]; = [[Microsoft Windows|WindowsCross-platform]]

| platform = [[x86 architecture|x86]], [[x86-64]], [[SPARC]], [[MIPS architecture|MIPS]], [[PowerPC]]

| size =

| language = C/C++

| programming language = [[C (programming language)|C]]/[[C++]]

| genre = [[Database engine]]

| license = [[GNU General Public License]]

| website = [http://mysql.bkbits.com = http://mysql.bkbits.com]

}}

'''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.