Hi Gasper, MySql allows to package the index - to get its size smaller and to gain performance. Some information about that can be found here: http://www.mysqlperformanceblog.com/2006/05/13/to-pack-or-not-to-pack-myisam-key-compression/
Gaspar Bakos schrieb: > Hi, > > > RE: > >> Have you tried >> analyze table x; >> > > This was quick: > > mysql> analyze table TEST; > Table Op Msg_type Msg_text > CAT.TEST analyze status Table is already up to date > > -------------------------- > > mysql> show index from TEST; > +-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | > Cardinality | Sub_part | Packed | Null | Index_type | Comment | > +-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > | TEST | 1 | MMtestfiel | 1 | MMtestfiel | A | > 838 | NULL | NULL | | BTREE | NULL | > | TEST | 1 | MMi_m | 1 | MMi_m | A | > 25857 | NULL | NULL | YES | BTREE | NULL | > +-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > > > --------------------------- > I am trying to figure out what the "Packed" field means. > > Gaspar > >
smime.p7s
Description: S/MIME Cryptographic Signature