MySQL Forums
Forum List  »  Archive Storage Engine

Archive Storage Engine Config Parameters
Posted by: Sujit S
Date: February 10, 2011 11:41PM

Hi All,

Does Archive Storage Engine support config parameters to change the read and log buffer size (something similar to innodb config parameters). We were moving one of our table from innodb to archive. The insert operation into the archive table shows a very big improvement. However the select operation requires the same amount of time. Since archive engine uses compressed data we were hoping to see some improvement in the select operation as well. Since this is not the case, we were thinking that increasing the read buffer size might help.

Please let me know your comments. Is there some other way to improve select performance on archive engine.

Thanks and Regards

P.S. The table is partitioned by date , is not indexed and all the queries on it do a full table scan.

Options: ReplyQuote

Written By
Archive Storage Engine Config Parameters
February 10, 2011 11:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.