… sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be done by key_cache rather than sort… many tables which are being repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table will be…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
I have written before – MyISAM Does Not Scale, or it does quite well – two main … the sum key buffer size (4000000000 in this case) and actual index size: select concat(“SET GLOBAL “, t.table_schema,”_”,t.table_name,”.key_buffer_size=”,round….key_buffer_size=28390400; | +———————————————+ 2 rows in set (2 min 31.68 sec) Pass this via SELECT INTO OUTFILE or pipe it to mysql…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… very similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only. But talking… fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer to optimize data retrieval – As data is sorted by the key…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql …MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. …size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… ( myisam_sort_buffer_size is normally set pretty lage). If this becomes the problem I use tiny script which moves out all MyISAM tables… failure handling scenarios. Cold Start – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… is key buffer contention which unlike popular belief not fully fixed by changes done in MySQL 4.1 As Monty explained us in MySQL… second confirmation that key_cache is a problem is benchmark run with disabled key_cache (=0). Results for MyISAM with key_buffer_size=0 Threads queries…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql…MyISAM because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL…on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… measure the memory usage for each test. I did allocate buffers in what I hope was a realistic way. For instance… innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated that memory to into key_buffer_size… FT index before declaring the `FTS_DOC_ID` primary key column properly, MySQL crashed with an out of memory fatal error, and…
Post: FreeBSD tests
June 15, 2006 By 15 Comments
…. For MyISAM Suse is stable better. Configuration params: Box: Dual Core Athlon 3800+, 1Gb of RAM, Motherboard ASUS A8N-E MySQL 5.0.22 params for InnoDB: –innodb-buffer-pool-size=500M –max-connections=500 params for MyISAM: –key-buffer-size=500M –max-connections…
