Re: Archive Engine Question

2013-09-19 Thread Tim Callaghan
If you are looking for great compression another option is TokuDB. It supports quicklz, zlib, and lzma compression. On Wed, Sep 18, 2013 at 2:30 AM, Manuel Arostegui man...@tuenti.com wrote: 2013/9/17 Wayne Leutwyler wleut...@columbus.rr.com Hello List, I have a customer who is wanting

Re: Archive Engine Question

2013-09-18 Thread Manuel Arostegui
2013/9/17 Wayne Leutwyler wleut...@columbus.rr.com 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

Archive Engine Question

2013-09-17 Thread Wayne Leutwyler
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.

Re: Archive Engine Question

2013-09-17 Thread Keith Murphy
From here: http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html The ARCHIVE engine supports INSERThttp://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,

Re: Archive Engine Question

2013-09-17 Thread Wayne Leutwyler
Yea, the more I think about it the more it makes good sense. Are there any special my.cnf setting we should be looking at. We currently have our systems tuned for InnoDB as our primary engine. Thanks for the feedback Keith. On Sep 17, 2013, at 11:34 AM, Keith Murphy bmur...@paragon-cs.com