… #*** 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_max…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…_size = 64M serverid = 101 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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…myisam_max_sort_file_sizeblogpercona.commanual myisam_mmap_sizeblogpercona.commanual myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only…only row pointers together with key value – which are offsets for MyISAM and primary key values for Innodb … are long so they are longer than max_length_for_sort_data it would frequently …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… 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 which can take even longer. Be careful with myisam… many tables which are being repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… [Buffers] join_buffer_size = 32M key_buffer_size = 640M myisam_sort_buffer_size = 64M sort_buffer_size = 4M read_rnd_buffer_size = 12M read_buffer_size = 4M [Server... = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock [Server] server…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… key_cache_age_threshold, key_cache_block_size, key_cache_division_limit Key Cache/Key Buffer replacement algorithm configuration variables. Obviously only apply to MyISAM as key_buffer… So in practice this option is used for MyISAM and MEMORY tables. max_write_lock_count Variable which may save you …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…> set global key_buffer_size=8000000; Query OK, 0 rows affected (0.03 sec) mysql> set global max_heap_table_size=1000000000; Query OK… catches me. For 1M rows we have mysql> set max_heap_table_size=1000000000; Query OK, 0 rows affected (0.00 sec… you to read through here is the summary: key_buffer_size is important for MyISAM temporary tables performance to avoid OS writes OS…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…`,`REMARKS`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CNF ——- [mysqld] socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer_size…
