2013/9/17 Wayne Leutwyler <wleutwyl@stripped>
> 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.
We use Archive for archive clusters (obviously) and it is a good option to
save lot of disk space if you assume the performance can be slightly worse.
As Keith has pointed out, make sure you know which statements you use
because ARCHIVE doesn't support all the MySQL ones.
If Archive isn't an option but you still want to save some disk, you can
use InnoDB Compression:
In all the tests we did we saw some performance degradation but nothing too
serious and nothing we couldn't afford, but if you decide to try this, make
sure you do a PoC so you know how it could impact in your scenario.
Hope this helps