…with some roll-up aggregation, which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY…thread_cache_size = 1000 query_cache_size = 0 query_cache_…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…cache“, “FlashCache”, “vCache with no time-based flushing”, and “vCache with time-based flushing.” As the images demonstrate, the no-cache…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… 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 which can take even longer. Be careful with myisam… being repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table will be locked while repair…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… for with this setup. Performance ? This configuration adds effectively global table locks besides extra overhead you get from external locking. Plus key cache have to be invalidated with remote writes which makes even less efficient. So… as I remember MySQL simply was not repairing corrupted tables in this configuration even if myisam_repair is set. Space Saving ? As I…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably the most important issue – with modern multi core… at the time can be the problem, not to mention Key Cache which often becomes serious contention issue. The problem we often… can keep main data in Innodb but build a “shadow” MyISAM table which is used for full text search. In certain…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…myisam_mmap_sizeblogpercona.commanual myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona.commanual myisam_stats_methodblogpercona.commanual myisam…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… however rather painful to use with web applications – users may issue different queries which may trigger check/repair running for many tables… you might want to populate caches. For MyISAM key_cache this can be done by using LOAD INDEX INTO CACHE statement, for other storage engines…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE, REPAIR TABLE commands. For OLTP applications with simple queries… values to run some queries. There can be mutiple key caches. Multiple key caches can be created to accomodate query executions Query Parsing and…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… 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_recover… seqwr with WT cache: Here’s same test with WB cache: And just to show you the difference between sequential writes with WT cache and WB cache…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… Obviously the result is quite better with bigger logs, so size does matter…cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key…8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_…
