MySQL Forums
Forum List  »  Partitioning

Re: Wether is it possible to compress partitioned MyISAM tables?
Posted by: Allan Winston
Date: August 07, 2009 02:38AM

Allen,

Everything I have read in the manuals indicates that compressing the partitions of MyISAM tables is legal. If I understand correctly, you can have a mixture of compressed and un-compressed partitions.

I have been using compressed on my own project. For this table, I am using I am using Range-Partitioning.

I do not normally run "alter table tbl-name analyze partitions All". owever, when I ran it on my table if got a Msg_type = "error" and Msg-Text "Table tbl_name is read-only".

On a related subject, you may run into a significant bottleneck in loading data into a table with such a large number of partitions. This is documented at:
http://bugs.mysql.com/bug.php?id=37252 .

Allan

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Wether is it possible to compress partitioned MyISAM tables?
3426
August 07, 2009 02:38AM


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.