Best MySQL storage engine for read heavy table with two indexes
The biggest downside for ARCHIVE in your environment would be that it won't work.  

The ARCHIVE storage engine only supports INSERT and SELECT -- not UPDATE or DELETE -- and only supports one index, on the primary key.

I would to go with InnoDB, which can, incidentally, also store tables compressed on disk.  I can't think of a good reason to go any other way.