MySQL:ARCHIVE

MySQL, Work Add comments

+ 400% performance increase in comparison with packed MyIsam (according to Livejournal people)
+ 20% less storage space in comparison with packed MyIsam
+ with really big tables > 1.5Gb table scan on ARCHIVE beats MyIsam
- no indexes whatsoever, not even primary keys
- MERGE can not be used

Похожие записи:

Leave a Reply

Entries RSS Comments RSS Log in Admin