List:General Discussion« Previous MessageNext Message »
From:Keith Murphy Date:September 17 2013 3:34pm
Subject:Re: Archive Engine Question
View as plain text  
From here:

http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html

The ARCHIVE engine supports
INSERT<http://dev.mysql.com/doc/refman/5.0/en/insert.html>
 and SELECT <http://dev.mysql.com/doc/refman/5.0/en/select.html>, but not
DELETE <http://dev.mysql.com/doc/refman/5.0/en/delete.html>,
REPLACE<http://dev.mysql.com/doc/refman/5.0/en/replace.html>,
or UPDATE <http://dev.mysql.com/doc/refman/5.0/en/update.html>. It does
support ORDER BY operations,
BLOB<http://dev.mysql.com/doc/refman/5.0/en/blob.html> columns,
and basically all but spatial data types (see Section 12.16.4.1, “MySQL
Spatial Data
Types”<http://dev.mysql.com/doc/refman/5.0/en/mysql-spatial-datatypes.html>).
The ARCHIVE engine uses row-level locking.

*Storage:* Rows are compressed as they are inserted. The ARCHIVE engine
uses zlib lossless data compression (see http://www.zlib.net/). You
can use OPTIMIZE
TABLE <http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html> to
analyze the table and pack it into a smaller format (for a reason to
use OPTIMIZE
TABLE <http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html>, see
later in this section). Beginning with MySQL 5.0.15, the engine also
supports CHECK TABLE<http://dev.mysql.com/doc/refman/5.0/en/check-table.html>.
There are several types of insertions that are used:


You tell my why a customer who wants to place AUDIT information in a table
might want that?

Keith Murphy
http://www.paragon-cs.com

-- 

(c) 850-637-3877

On Tue, Sep 17, 2013 at 10:19 AM, Wayne Leutwyler
<wleutwyl@stripped>wrote:

> Hello List,
>
> I have a customer who is wanting to use the Archive Engine. I have no
> experience with this engine, other than what I am been reading. Why would I
> want to use Archive over InnoDB. They are only going to be placing audit
> information in the table.
>
> Walter "Wayne" Leutwyler, RHCT
> Sr. MySQL Database Administrator
> Mobile: 614 519 5672
> Office: 614 889 4956
> E-mail: wayne.leutwyler@stripped
> E-mail: wleutwyl@stripped
> Website: http://penguin-workshop.dyndns.org
>
> "Courage is being scared to death, but saddling up anyway." --John Wayne
>
>

Thread
Archive Engine QuestionWayne Leutwyler17 Sep
  • Re: Archive Engine QuestionKeith Murphy17 Sep
    • Re: Archive Engine QuestionWayne Leutwyler17 Sep
  • Re: Archive Engine QuestionManuel Arostegui18 Sep
    • Re: Archive Engine QuestionTim Callaghan19 Sep