Re: Wether is it possible to compress partitioned MyISAM tables?

[Allan Winston]

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