… so improving performance dramatically. Actually packed indexes not a bit longer rows is frequent reason of MyISAM performing better than Innodb. In… size reduces if PACK_KEYS=1. Might be it is some kind of special hack 
The fact MyISAM will by default compress… `c` (`c`), KEY `id` (`id`) ) ENGINE=MyISAM Index size: PACK_KEYS=DEFAULT – 1550K PACK_KEYS=1 – 1453K PACK_KEYS=0 – 8176K As we can…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… for MYISAM: mysql> show index from antest; +——–+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed… equal when computing stats: mysql> show variables like “myisam_stats_method”; +———————+—————+ | Variable_name | Value | +———————+—————+ | myisam_stats_method | nulls_unequal | +———————+—————+ 1 row in…
Post: Beware of MyISAM Key Cache mutex contention
August 12, 2008 By 10 Comments
… work done than one would hope. As we already discussed MyISAM key cache has serious mutex contention issue as there is… copied from key_cache to the thread local space. Happily MyISAM allows you to create multiple key caches . We use “keycache… tenfold and performance almost doubled. Another interesting result was – adding PACK_KEYS=0 to most actively updated tables almost doubled throughput…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… were recently number of posts about MyISAM, for example Arjen wrote pretty nice article about MyISAM features so I thought I would… this happened make sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be… storage engine can be even better. Read only data, especially packed with myisampack. This can’t be corrupted or updated and…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
… the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the… to do insert into MyISAM_table select * from MyISAM_table1 and so on for the 16 files. Since MyISAM are flat files, that… -rq test_concat – check record delete-chain – recovering (with sort) MyISAM-table ‘test_concat’ Data records: 3 – Fixing index 1 myisamchk…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2009 By 117 Comments
How about a speed test with a MyISAM-packed table vs InnoDB? InnoDB’s great, but if you’re uploading massive tables back and forth to your server, MyISAM will be less of a hassle due to much smaller files.
Comment: To pack or not to pack - MyISAM Key compression
November 2, 2012 By 4 Comments
… information. I have done a test to turn all the pack_keys in a Discuz! database into 1, in a middle… also have a question, that you said “Be careful with PACK_KEYS=0 as it can blow up your index size… with a table, whose index declines when PACK_KEYS=0(changed from DEFAULT). MyISAM seems to set a limit to the mixinum…
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
September 30, 2009 By 30 Comments
… for fast DW queries. I don’t get that from MyISAM+MySQL. IIRC LucidDB supports 1 writer with N readers via… column for each block of a database file (data packs or data pack nodes in Infobright) is also used by Netezza (they…). Although Infobright does more this storing aggregated values per data pack. Monty also spoke at the MySQL Conference about this and…
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
September 30, 2009 By 30 Comments
… loaded into MyISAM and into MonetDB. The data’s random distribution surely works against the “knowledge grid” and “data pack” layout. I…(), MIN() and MAX() would be computed and stored per “data pack” so the query could be simply answered from the meta…’s a WHERE clause naturally all the rows in the pack have to be examined — but I would expect that to…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… Checksum: NULL Create_options: Comment: *************************** 2. row *************************** Name: cbool Engine: MyISAM Version: 10 Row_format: Fixed Rows: 2097152 Avg_row_length… many flag values to deal with which you can’t pack to the bitmask this approach can be quite helpful.
