….commanual myisam_block_sizeblogpercona.commanual myisam_data_pointer_sizeblogpercona.commanual myisam_max_sort_file_sizeblogpercona.commanual myisam_mmap_sizeblogpercona.commanual myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… this table – myisam_data_pointer_size is 6 default plus we need space for delete flag which makes 7 minimum row size MyISAM can have in…: MyISAM Version: 10 Row_format: Fixed Rows: 2097152 Avg_row_length: 11 Data_length: 23068672 Max_data_length: 3096224743817215 Index_length: 1024 Data_free…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache_size = 80 query_cache_size = 32M thread_concurrency = 8 query_cache_type = 1 query_cache_limit = 32M thread_stack=256K myisam_data_pointer_size=6…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… be encoded as “aaaaaa”, “b”. The similar compression applies to data pointer for the same key value. It also can be used… “key” the size reduces if PACK_KEYS=1. Might be it is some kind of special hack 
The fact MyISAM will by… NULL default ”, KEY `c` (`c`), KEY `id` (`id`) ) ENGINE=MyISAM Index size: PACK_KEYS=DEFAULT – 1550K PACK_KEYS=1 – 1453K PACK_KEYS…
Comment: TPC-H Run on MySQL 5.1 and 6.0
June 17, 2009 By 16 Comments
Luca, It looks like you have 2G file size limit somethere. MySQL does not have 2G limit – even with small data_pointer_size for MyISAM tables you will get at last 4G So I’d look at OS settings, may be quota.
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only. But talking… only row pointers together with key value – which are offsets for MyISAM and primary key values for Innodb or storing full data which…_rnd_buffer_size is important (optimization works in following conditions): Row pointers are stored in the sort_buffer, not the whole data selected…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… to verify and benchmark performance while varying the size of the sort_buffer. It is my …MyISAM table with one char column without an index: CREATE TABLE `sorttest` ( `data` char(30) DEFAULT NULL ) ENGINE=MyISAM… bytes) but if the structure has a few pointers, that can add up to such amount of…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… was for a while comparing PBXT to MyISAM with multi versioning and transactions and this…pointer each rows has fixed data part and dynamic data parts stored in separate files. Dynamic length part is stored in file called “Data…require a lot of IO for large data sizes. But you of course should take …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…appended to it internally anyway. For MyISAM table you should use K(id2… which are accessed frequently. The size of this “working set” can … because by scanning data in index order MySQL gets data in already sorted order… linked list – each leaf page contains pointers to both previous and next pages…
Comment: Using MyISAM in production
June 18, 2006 By 36 Comments
… serilized data, such as XML and its size is always growing. Here is how to see it: # myisamchk -dvv table.MYI MyISAM file… Status: open,changed Data records: 46749 Deleted blocks: 0 Datafile parts: 46793 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 Datafile…
