…). For the MyISAM tests I used a 10GB key buffer. I used ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE ENABLE KEYS…=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… (I will use INSERT .. ON DUPLICATE KEY UPDATE statements for that), so it will produce all …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_extra_sort_file_size = 10G myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… results. Disclosure: The research and testing conducted for this post were sponsored by Virident. First, …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: Beware: key_buffer_size larger than 4G does not work
February 14, 2007 By 17 Comments
… RAM running MyISAM, so they set key_buffer_size to 16G… and every few days MySQL crashes. Why ? Because key_buffer_size over 4GB in size is not… just fine until you have less than 4GB worth of key cache used and then it would crash. If you do… this bug was known for years and not only fix was not made available but even maximum key_buffer_size was not restricted to…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…before – MyISAM Does Not Scale, or it does quite well …could use multiple key caches for the same table, for example caching even/odd key blocks or something …key buffer size (4000000000 in this case) and actual index size: select concat(“SET GLOBAL “, t.table_schema,”_”,t.table_name,”.key_buffer_size…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… for scientifically choosing a key_buffer_size setting, but there are many unscientific approaches that are better than ratio-based tuning. Counter ratios suck for everything, not just for MyISAM…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…next releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix…=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M …
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 to Monty today I learned it is not the case. read_rnd_buffer can be used for… together with key value – which are offsets for MyISAM and primary key values for Innodb or storing full data which is being retrieved (good for small…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… 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/sec 1 128 2 113 4 193 8 196 16 195 The result for…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size = 64M read_buffer_size = 16M sort_buffer_size = 8M table_cache = 3600 table_definition_cache = 4096 thread_cache_size….log # Default to using old password format for compatibility with mysql 3.x # clients (those …
