[Maria-discuss] New Question: ARCHIVE equivalent
![](https://secure.gravatar.com/avatar/b08670b8f8b6a0eea81857347b9ce12e.jpg?s=120&d=mm&r=g)
Hello, A new question has been asked in "MariaDB FAQ" by dumdummare: -------------------------------- What options are there to have a log table that is difficult to change but quick to search using criterias even during inserts? Something like an ARCHIVE with indicies or an InnoDB without UPDATE or DELETE. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/archive-equivalent/
![](https://secure.gravatar.com/avatar/392856b43200ef35060b655747853c7c.jpg?s=120&d=mm&r=g)
Hi,
I would suggest TokuDB, though you will have to enforce the "no updates"
rule with permissions. Like ARCHIVE, TokuDB is compressing, but unlike
ARCHIVE it is also MVCC and has tunable compression levels. I'd recommend
an auto_increment to keep insertions in sorted PK order. The secondary
keys (as long as they aren't unique) can be maintained /very/ efficiently
in TokuDB, particularly if certain limitations with respect to binary
logging are allowed.
On Tue, Feb 11, 2014 at 9:56 AM, Roberto Spadim
aria engine, i think
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
![](https://secure.gravatar.com/avatar/2954f31ff461bc5109ae8b1bfcfdf683.jpg?s=120&d=mm&r=g)
Not to rain on anyone's parade, but the OP will never see these responses as the KB doesn't parse emails. You are supposed to login to the KB and answer there. Brian On 2/11/2014 1:46 PM, Justin Swanhart wrote:
Hi,
I would suggest TokuDB, though you will have to enforce the "no updates" rule with permissions. Like ARCHIVE, TokuDB is compressing, but unlike ARCHIVE it is also MVCC and has tunable compression levels. I'd recommend an auto_increment to keep insertions in sorted PK order. The secondary keys (as long as they aren't unique) can be maintained /very/ efficiently in TokuDB, particularly if certain limitations with respect to binary logging are allowed.
On Tue, Feb 11, 2014 at 9:56 AM, Roberto Spadim
mailto:roberto@spadim.com.br> wrote: aria engine, i think
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss https://launchpad.net/%7Emaria-discuss Post to : maria-discuss@lists.launchpad.net mailto:maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss https://launchpad.net/%7Emaria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
serious? i post some time ago and the message was sent to kb page, or maybe
i was drunk?
2014-02-11 16:50 GMT-02:00 Brian Evans
Not to rain on anyone's parade, but the OP will never see these responses as the KB doesn't parse emails.
You are supposed to login to the KB and answer there.
Brian
On 2/11/2014 1:46 PM, Justin Swanhart wrote:
Hi,
I would suggest TokuDB, though you will have to enforce the "no updates" rule with permissions. Like ARCHIVE, TokuDB is compressing, but unlike ARCHIVE it is also MVCC and has tunable compression levels. I'd recommend an auto_increment to keep insertions in sorted PK order. The secondary keys (as long as they aren't unique) can be maintained /very/ efficiently in TokuDB, particularly if certain limitations with respect to binary logging are allowed.
On Tue, Feb 11, 2014 at 9:56 AM, Roberto Spadim
wrote: aria engine, i think
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
participants (4)
-
AskMonty KB
-
Brian Evans
-
Justin Swanhart
-
Roberto Spadim